Delete unique values from a row
 

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!
--
Essie

Delete unique values from a row
 

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


"Essie" wrote:

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!
--
Essie

Delete unique values from a row
 

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

"Mike H" wrote:

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


"Essie" wrote:

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!
--
Essie

Delete unique values from a row
 

Sorry same thing different words. ooops

"AussieBec" wrote:

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

"Mike H" wrote:

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


"Essie" wrote:

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!
--
Essie