Forum Discussion
Need a Formula Solution
I have two worksheets of patient data in excel. Each list has patient records and one of the values in each is a patient account number. One list is those who are deceased. I need to find and match t...
Let's say the patient list is on Sheet 1, with account numbers in column A.
And the list of deceased patients is on Sheet 2, also with account numbers in column A, in A2:A1000.
In the first empty column on Sheet 1, enter Deceased in row 1.
In row 2, enter the formula =ISNUMBER(MATCH(A2, 'Sheet 2'!$A$2:$A$1000, 0))
Fill down from row 2 as far as needed.
You can filter the new column for TRUE, then delete the filtered rows.