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 the account numbers that are in the deceased list and remove them from our main list. I tried the CountIf function but I couldn't get it to work. It would be fine if it gave me a "1" in a new column to signify a match because I can then just sort and delete any of them with a 1. But again, I couldn't get it to work. Also, the number match has to be EXACT because some would be for example 14558 and another may be 145588 and that wouldn't be a match for my case.