Delete unique values from a row

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello All,

I have a sheet with two columns and a lot of rows.
In the first column there are duplicates, the second column are all unique
codes.
I need to have the unique codes highlighted or deleted, so I can recognise
the duplicates and their unique codes in column two.
Please let me know if this is not clear.
Thanks a lot for your help!
 
You can highlight the duplicate codes in Col A.

Select the data range in Col A and then:-

Format|conditional formatting.

Cahnge the dropdown to Formula is and paste this formula in:-

=IF(COUNTIF(A1:A100, A1)>1,TRUE,FALSE)
Pick a colour.

You can extract unique entries to another column with:-

=IF(COUNTIF($A$1:A1,A1)=1,A1,"")

If your data start in A1 put this in (say) c1 and drag down.

Mike
 
Here's another formual that I use to find unique and duplicates, I then use
filters.

=IF(COUNTIF(E2:E2098,E2)>1,"Duplicate","Unique")

Hope this helps too.

Bec
 
Sorry same thing different words. ooops

AussieBec said:
Here's another formual that I use to find unique and duplicates, I then use
filters.

=IF(COUNTIF(E2:E2098,E2)>1,"Duplicate","Unique")

Hope this helps too.

Bec
Click to expand...
 
Back
Top