I have a spreadsheet that I need to sort. I want to either sort or highlight all the values in a column that are duplicate. Is there a way to do this???
I have a spreadsheet that I need to sort. I want to either sort or highlight all the values in a column that are duplicate. Is there a way to do this???
Hi,
Presuming your list is in the range A1:A100,
Use this in conditional formatting > Formula is
=COUNTIF($A$1:$A$100,A1)>1
Rule 1: Never merge cells
Rule 2: See rule 1
"Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".
Or, if you want only the duplicates highlighted, leaving the first of each entry alone, change Sweep's formula to =Countif($A$1:$A1,A2) and begin at A2.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks