Hello
I'm having some bother trying to figure this out. I have a sample workbook attached.
What I would like to do:
If the persons board number (B:B) is a duplicate AND their admission date (C:C) is a duplicate, i would like to delete the SECOND value of their duplication (i.e. row 4 in attached example, because his referral time is later than that of the referral in row 3). Or if it were to say "Delete" or something so that i can filter it out and delete it manually.
IF that does not make sense i can clarify further. I have a huge amount of data (and more will be coming regularily) so although i could do it manually, i would prefer to figure this out.
Bookmarks