I need to identify, and custom format rows that have duplicate data based on data in 5 columns. My goal is for the formatting formula to:
Highlight the rows where data in columns A, B, C, D, and E are all identical to any other rows on the sheet.
My initial run with the COUNTIFS ($A$2:$A$XXX,$A2,...,$E$2:$E$XXX,$E2)>1 has not worked consistently. It still locates and highlights cells that only have 2 out of the 5 columns matching, and for some reason, it will randomly highlight a unique row, where nothing matches anything else on the sheet.
I have a sheet like this come to my desk every day, and visually finding the duplicates can be tedious.
Here's today's data set for me to sort.
Bookmarks