Results 1 to 6 of 6

Thread: Advanced Filter

  1. #1
    New Lounger
    Join Date
    Feb 2001
    Location
    Arlington WA
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Advanced Filter

    Advanced Filter

    Maybe you can help me use the Advanced Filter to do a unique filter of a list of 10 columns by 66 rows that has duplicates in it. My list has a header on each column, simply 1 thru 10. I find I can filter each column separately to a new location, that is 10 separate operations. But can it be done more directly in one operation.

    Thank you, Maurice

  2. #2
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    St. George, Maine, USA
    Posts
    158
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Advanced Filter

    Please specify Excel Version & SR.

    The advanced filter handles at least 10 columns.
    But not knowing the criteria you setup it is difficult to make any comment. A simple example that fails to meet your expectations would help.
    A common error in using the advanced filter is establishing the criteria properly. Are you using 'AND' or 'OR' column matches? . . .

    Bob_D

  3. #3
    New Lounger
    Join Date
    Feb 2001
    Location
    Arlington WA
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Advanced Filter

    Using XCEL2000 (9.0.2720)

    Below is a small sample of my list in Excel. Here is how I successfully use the Advanced Filter do the Unique filter on the first column: Checked are

  4. #4
    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

    Re: Advanced Filter

    Hi Maurice,
    If I understand you correctly, you want one final list that contains a unique entry for each possible value in each column in your original data, rather than a list containing data where each entire row is distinct? I don't believe that that can be done using Advanced Filter - it treats each entire row as one record and so will only remove records where every column is the same as another record. You do need to treat each column individually if you want to simply remove duplicates from that one column.
    I hope that makes some sense?
    Regards,
    Rory

    Microsoft MVP - Excel

  5. #5
    New Lounger
    Join Date
    Feb 2001
    Location
    Arlington WA
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Advanced Filter

    Yes a simple a simple unique list in any configuration of the whole list.

    Thanks: M.baum

  6. #6
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    St. George, Maine, USA
    Posts
    158
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Advanced Filter

    The attached workbook contains some examples using your data. Activate any data cell & then activate the advanced filter to see the options in sheets 1, 2 & 3.
    On sheet 4, Cell A15 can be changed to any value within the matrix.

    The explanation of what you want is really not to clear to me. Could you simply show what the results you would like to be. I work best by example. The advanced filter may not do what you want.

    Bob_D
    Attached Files Attached Files

Posting Permissions

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