excel unique values in column

  • Thread starter Thread starter rodchar
  • Start date Start date
R

rodchar

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
 
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
 
thanks for the help,
rod.

Mike H said:
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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

countif - unique values only 8
Conditionally count unique values 2
filter column unique for alphanumeric 3
Suggestion for Macro to Delete Dups based on all fields 4
If value in a colum the same concatenate another colume 4
2 columns processing 2
search column for duplicate value during data entry 3
**finding duplicates from multiple columns and highlighting** 1

Back
Top