Need help configuring for patient data


Ok I have a spreadsheet with different patient names. If they are inpatient then there is a column that is blank. Once they are discharged, that blank space is filled with a date. SO what I Need daily is for it to give me a list of the patient names that are still here (blank spaces. I am at a complete loss;