A formula is operating the opposite of what I am expecting.
I want to apply conditional formatting of white text to hide the second and subsequent duplicates in a sheet. I've tried several different formulas but they aren't working.
When I apply this formula:
=COUNTIF($A$2:$A2,A2)>1
It shows the LAST duplicate but hides all the previous ones... I want it to do the opposite -- show the first but hide the rest. What am I doing wrong?![]()
Bookmarks