Copy a column and paste only unique values

Mar 8th, 2002, 02:01 PM

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 · Mar 8th, 2002, 02:07 PM

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

Mark W. · Mar 8th, 2002, 02:08 PM

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 ]

Mar 8th, 2002, 02:34 PM

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

Thanks!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 8th, 2002, 02:01 PM	#1
Guest Posts: n/a	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

Mar 8th, 2002, 02:07 PM	#2
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	You could use an advanced filter, check the unique records only box, copy and paste and then use advanced filter- show all.

Mar 8th, 2002, 02:08 PM	#3
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	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 ]

Mar 8th, 2002, 02:34 PM	#4
Guest Posts: n/a	The advanced filter worked great. I used the Copy to Another Location option which allowed me to do it all in one step. Thanks!