Deleting, but only if data in B:B are duplicates AND data in C:C are duplicates

[gillcork22]

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.

[JieJenn]

I checked Excel official page and the page states Excel 2007 supports COUNTIFS, so use the COUNTIFS function to check the duplicates. In G2, enter this formula =COUNTIFS($A$2:$A2, $A2, $B$2:$B2,$B2) > 1 and fill the formula. Since you are using "Excel table", the formula should automatically be filled. The "duplicate" rows will return TRUE.