Return list of results. from a list, if cell value is blank

[TheOnlyJme]

Hi,

I'm helping a friend improve his patient list (He works for the National Health Service in the UK).

He wants a 'view' of his patient list that only shows current patients (i.e. a second sheet with duplicate data, if the patient's discharge date is not set (blank)).

The patient lists contains 20 columns of data (name, ID, condition, discharge date etc). The team don't want to use filters but would like to have a duplicate sheet (with identical look and feel) that only shows patients who are still under there care, based on the fact that there is no discharge date. Sheet 1=Patients Sheet, 2=Current Patients, Column I contains 'Date of discharge from hospital'.

I thought I should be able to achieve this using Vlookup with Match and possibly If. But can't find the right combination of functions to use.

Due to security, I'm not able to use VBA.

Thanks in advance!!
Jamie

 

[TheOnlyJme]

If it helps the layout is something like this:

[TABLE="class: grid, width: 300, align: center"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Patient ID[/TD]
[TD]DOB[/TD]
[TD]Age[/TD]
[TD]Sex[/TD]
[TD]Admission Date[/TD]
[TD]Referral Date[/TD]
[TD]1st Treatment Date[/TD]
[TD]Discharge Date[/TD]
[/TR]
[TR]
[TD]Jamie[/TD]
[TD]123454[/TD]
[TD]1/12/70[/TD]
[TD]42[/TD]
[TD]M[/TD]
[TD]06/1/18[/TD]
[TD]08/1/18[/TD]
[TD]09/1/18[/TD]
[TD]07/2/18[/TD]
[/TR]
[TR]
[TD]Paula[/TD]
[TD]876545[/TD]
[TD]18/8/79[/TD]
[TD]37[/TD]
[TD]F[/TD]
[TD]12/1/18[/TD]
[TD]12/1/18[/TD]
[TD]13/1/18[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Carl[/TD]
[TD]75664[/TD]
[TD]31/8/80[/TD]
[TD]36[/TD]
[TD]M[/TD]
[TD]19/1/18[/TD]
[TD]20/1/18[/TD]
[TD]20/1/18[/TD]
[TD]30/1/18[/TD]
[/TR]
</tbody>[/TABLE]

So in this example I only want Paula to show up on the 'view' sheet and then underneath all the other patients with a blank Discharge Date.