| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Unique list of entries
I have a column of texts. Some of cells are repeated. I want to obtain
unique column of texts. How can I obtain it. Data I have: aaa bbb ccc aaa ddd bbb I want to obtain: ( In a separate column) aaa bbb ccc ddd |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Unique list of entries
One method is to use Advanced Filter - Select the range including the header
row, Data-Filter-Advanced Filter, choose copy to another location, check unique records only and enterthe destination cell where it asks where you want to copy to. -- Kevin Vaughn "Rasoul Khoshravan" wrote: I have a column of texts. Some of cells are repeated. I want to obtain unique column of texts. How can I obtain it. Data I have: aaa bbb ccc aaa ddd bbb I want to obtain: ( In a separate column) aaa bbb ccc ddd |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| tagging unique items in a list | Excel Worksheet Functions | |||
| Displaying unique entries from a filtered list | Excel Worksheet Functions | |||
| Count Unique Entries | Excel Worksheet Functions | |||
| Counting unique text entries in a filtered list... | Excel Worksheet Functions | |||
| Unique numbers from data validation list | Excel Worksheet Functions | |||
Linear Mode
