Good morning,
I need to isolate duplicates in a spreadsheet that are represented by three columns that are the same and where the duplicate data occurs in different rows. I'm working with a class schedule that has over 4500 lines and each course is identified by data in three columns, e.g. ART 101 01. The IF function, e.g. =IF(AND(A3=A4,B3=B4,C3=C4),"YES","NO"), works at identifying one row of the duplicate but I need to isolate both rows together so that I can edit the data. I have tried to nest an OR/AND function e.g. =IF(OR(F2=F3,G2=G3,H2=H3)*AND(A3=A2,B3=B2,C3=E2),"YES","NO") but this does not work. I have attached a sample spreadsheet. Any help or alternative approaches will be greatly appreciated!
Rocinante
SAMPLE - Duplicates in 3 Columns.xlsx
Bookmarks