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, parameter3 and parameter4.
Given data:
| test | parameter1 | parameter2 | parameter3 | parameter4 |
| 1 | a | b | c | c |
| 1.1 | a | b | c | b |
| 3 | a | c | d | d |
| 1.3 | c | r | f | f |
| 13 | b | b | a | a |
| 4 | c | r | f | f |
| 6 | a | h | f | f |
| 7 | c | r | f | f |
Required: Combination of parameter1, parameter3 and parameter4 is seen to be repeated for rows 5, 7,9 so need to highlight them.
Kindly let me know if you have a solution for this.
Regards
Kinjal
1 Reply
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
