Copy a column and paste only unique values
VBA Telemetry pings you when your VBA projects fail
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Copy a column and paste only unique values

  1. #1
    Guest

    Default

     
    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

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sunny, spring-like Hull
    Posts
    3,339
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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 ]

  4. #4
    Guest

    Default

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

    Thanks!

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com