+ Reply to Thread
Results 1 to 8 of 8

Using advanced filter in combination with other filters

  1. #1
    Registered User
    Join Date
    07-10-2009
    Location
    Hudson, New Hampshire USA
    MS-Off Ver
    Excel 2003
    Posts
    37

    Using advanced filter in combination with other filters

    I am having some problems trying to filter a list to display exactly what I want to see. The list has one column of part numbers, a second with due dates, and then another with quantity. I want to use an advanced filter on the part numbers to only look at unique entries. Then I want to filter that list using a custom filter on the due dates to only view those due within a certain period. So ultimately I want to view only unique entries due during a given period.

    I am able to apply one filter, but when I go to apply the second, the second filter removes the first. For example once I have filtered out duplicates, when I try to filter based on date all of the duplicates return. Is there any way to get around this?

    Thanks for any help.
    Last edited by ndenaro; 07-14-2009 at 12:02 PM.

  2. #2
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Using advanced filter in combination with other filters

    Edit: Nope, I was wrong, doesn't work for me either.

    You'll probably have to NOT filter in place.

  3. #3
    Registered User
    Join Date
    07-10-2009
    Location
    Hudson, New Hampshire USA
    MS-Off Ver
    Excel 2003
    Posts
    37

    Re: Using advanced filter in combination with other filters

    Even when filtering not in place, the advanced filter removes by original filter. Also, even if it didn't remove my first filter, the new column would not line up with the rest of the table.

  4. #4
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Using advanced filter in combination with other filters

    No, what I mean is you'll have to do step #1, then copy the visible data over to another spot/sheet where you can apply your AdvFilter. You can't do it in the same place as the original AutoFilter.

  5. #5
    Registered User
    Join Date
    07-10-2009
    Location
    Hudson, New Hampshire USA
    MS-Off Ver
    Excel 2003
    Posts
    37

    Re: Using advanced filter in combination with other filters

    gotcha, yes that would work

  6. #6
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Using advanced filter in combination with other filters

    If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].


    (Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated)

  7. #7
    Registered User
    Join Date
    07-10-2009
    Location
    Hudson, New Hampshire USA
    MS-Off Ver
    Excel 2003
    Posts
    37

    Re: Using advanced filter in combination with other filters

    If this is definately the only way to accomplish this then thats that, I would prefer to filter without having to copy and paste to another sheet but if we can confirm that it is necessary than I would call it solved. Thank you for all of your help.

  8. #8
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Using advanced filter in combination with other filters

    As per this thread's topic, and as stated in post #4: "You can't do it in the same place as the original AutoFilter."

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1