Forum Discussion
Highlight duplicate rows
Hi All, I am not able to find solution for below requirement. (Actual data is more than 1000 rows and has 40 columns.) I want to highlight rows that has duplicate of combination parameter1, para...
Hi Kinjal,
That could be the rule
=COUNTIFS($B$2:$B$10000,$B2,$C$2:$C$10000,$C2,$D$2:$D$10000,$D2,$E$2:$E$10000,$E2,$A$2:$A$10000,"<>"&"")>1
applied to your range