Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Jun 2005
    Posts
    386
    Thanks
    3
    Thanked 0 Times in 0 Posts
    I am trying to do an advance filter to filter out only the unique records. The procedure seems to be working on some of the records but not all of them. I still get two or more records on the unique record listing. I am copying to another location on the same worksheet. Any idea what is wrong. I am enclosing the listing.

    I guess I cannot have the original on one worksheet and the unique filtered records recorded on another worksheet.


    Attached Files Attached Files

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,433
    Thanks
    371
    Thanked 1,456 Times in 1,325 Posts
    MNN,

    Try the attached workbook as follows:

    Place your cursor on Sheet2!A7
    Select: Data->Filter->Advanced Filter
    Click OK when you get the warning message.
    Setup the Dialog Box as below:

    Seems to work fine. Often problems can be solved by using named ranges.

    RG
    Attached Images Attached Images
    Attached Files Attached Files
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  3. #3
    3 Star Lounger
    Join Date
    Jun 2005
    Posts
    386
    Thanks
    3
    Thanked 0 Times in 0 Posts
    Could you do a unique filter on a schedule with multiple columns?


  4. #4
    5 Star Lounger
    Join Date
    Dec 2009
    Location
    East Coast, USA
    Posts
    993
    Thanks
    8
    Thanked 43 Times in 43 Posts
    Hi MNN - See if the attached is what you were looking for in your original question.
    If you want, you can copy Col B to another worksheet.

    Please note: Your original file contains blanks in Col A from row 307 thru row 323, thus a blank appears as a unique record. You have over 5,000 rows of data to filter which is very simple to filter once the range is correct.

    Do you have sample data for your other question about filtering multiple columns?

    Tim
    Attached Files Attached Files

  5. #5
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    FYI you can use Advanced Filter to copy to a different sheet (without needing named ranges) but you need to select the sheet you want to copy to before you invoke the filter dialog.
    Regards,
    Rory

    Microsoft MVP - Excel

Posting Permissions

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