LinkBack URL
About LinkBacks
I need to highlight or display duplicate rows not duplicate values. If I would ask for duplicate values, it would display rows 2-4 but only rows 2-3 are identical and this is what I need to be displayed.
I need to highlight or display duplicate rows not duplicate values. If I would ask for duplicate values, it would display rows 2-4 but only rows 2-3 are identical and this is what I need to be displayed.
Select data range, apply new CF with formula and use...
Formula:
=COUNTIFS($A:$A,$A2,$B:$B,$B2,$C:$C,$C2)>1
"Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something."
― Robert A. Heinlein
Great. Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks