| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel unique values in column
hey all,
i have a single column of records that contain duplicates. what's the best way to get all the unique values and place in new column? thanks, rodchar |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
excel unique values in column
Hi,
Select the column of data then Data|Filter|Advanced filter Select 'unique records only' Select copy to another location Enter a location to copy to (A single cell not a range) Ok Mike "rodchar" wrote: hey all, i have a single column of records that contain duplicates. what's the best way to get all the unique values and place in new column? thanks, rodchar |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
excel unique values in column
thanks for the help,
rod. "Mike H" wrote: Hi, Select the column of data then Data|Filter|Advanced filter Select 'unique records only' Select copy to another location Enter a location to copy to (A single cell not a range) Ok Mike "rodchar" wrote: hey all, i have a single column of records that contain duplicates. what's the best way to get all the unique values and place in new column? thanks, rodchar |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Pivot Table - Counting Unique Values within one column of da | Excel Worksheet Functions | |||
| How do I get the unique values from a column in excel? | Excel Worksheet Functions | |||
| create list of unique values from a column with repeated values? | Excel Worksheet Functions | |||
| macro to transpose cells in Column B based on unique values in Column A | Excel Programming | |||
| How do I search thr'o column and put unique values in differnt sheet and sum corresponding values in | Excel Programming | |||
Hybrid Mode
