| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum duplicates unique values and delete dupliques | Excel Worksheet Functions | |||
| delete the test values, but do not delete the formulas | Excel Discussion (Misc queries) | |||
| delete records with unique value | Excel Discussion (Misc queries) | |||
| Count unique values and create list based on these values | Excel Worksheet Functions | |||
| create list of unique values from a column with repeated values? | Excel Worksheet Functions | |||
Hybrid Mode
