Copy a column and paste only unique values

[Guest]

I am wondering how to copy a column that could have repetitive values and paste it into another column with unique values only, in the fewest steps as possible. I can do it as follows.
1. Copy and paste into another column
2. Sort
3. Use "=If(D1=D2, "", D1)" and fill down to get unique values
4. Copy and Paste Special, Values - into another column
5. Sort again

Are there any quicker ways to do this?

Thanks

 

[Mudface]

You could use an advanced filter, check the unique records only box, copy and paste and then use advanced filter- show all.

 

[Mark W.]

You could use the approach that I describe here.

You could then apply an AutoFilter to the column containing the COUNTIF worksheet function, Copy the displayed rows, and Paste wherever you want.
This message was edited by Mark W. on 2002-03-08 13:10

 

[Guest]

The advanced filter worked great. I used the Copy to Another Location option which allowed me to do it all in one step.

Thanks!