Results 1 to 2 of 2

Thread: Advanced Filter

  1. #1
    3 Star Lounger
    Join Date
    Jun 2005
    Posts
    386
    Thanks
    3
    Thanked 0 Times in 0 Posts
    How do you use advance filter to get unique items copied to another section of the worksheet where the original list is located.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Start by duplicating the column headers to the location where you want unique records to be copied.
    Then click in the data table.
    Start Advanced Filter.
    Specify the list range (most likely it'll be selected already).
    Click "Copy to another location".
    Specify the duplicated column headers as Extract to range.
    Tick the check box Unique records only.
    Click OK.

Posting Permissions

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