I have a conditional formating formula that highlights duplicate entries.
How can I hide cells which aren't duplicates?![]()
=COUNTIF($E$2:$E$5000,E1)>1
I have a conditional formating formula that highlights duplicate entries.
How can I hide cells which aren't duplicates?![]()
=COUNTIF($E$2:$E$5000,E1)>1
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks