Dear Community - good morning.
In Column A I would like to highlight ALL duplicate values EXCEPT the first instance.
I thought this would work but alas!!
=IF(COUNTIF($A:A,A2)=1,FALSE,NOT(COUNTIF($A:A,A2)=1))
If anybody could assist i'd be gratefull.
Thanks
Bookmarks