Identifying Duplicates in Multiple Columns

[Rocinante]

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

[ChemistB]

=COUNTIFS($A$2:$A$33, A2, $B$2:$B$33, B2, $C$2:$C$33, C2)>1

Will return True for all duplicates (or triplicates, etc)
Is this what you are looking for?

[Melvinrobb]

You could also create a column like this:

Please Login or Register  to view this content.

Then highlight duplicates in this column.

[Rocinante]

Thanks, ChemistB,

This formula produced errors (see highlighted on the attached). I'm a long way from expert in Excel, and am always suspicious of the original data which coming from and Oracle software called Campus Solutions.

[Rocinante]

Thanks, MelvinRobb,

This method is working. Thank you very much!!!

Rocinante

[ChemistB]

Looks like it works. Row 20 matches row 24. Where are the errors?

[Rocinante]

Thank you again, ChemistB!

You are right!! The formula does work . . . and I really like it! I greatly appreciate the correction, not to mention the solution!

Jim