+ Reply to Thread
Results 1 to 7 of 7

Advanced filter not working right

  1. #1
    Registered User
    Join Date
    02-10-2010
    Location
    Mexico
    MS-Off Ver
    Excel 2003
    Posts
    5

    Advanced filter not working right

    I'm having problems using the "Unique record" function in the "advanced auto filter".
    When trying to filter a list of values, it is not completelly filtering the first value in the list.
    If I have a list of...
    A
    A
    A
    B
    B
    B
    C
    C
    C
    ... the filtered result will come up as...
    A
    A
    B
    C
    ...leaving 2 instances of the first value.
    I've also tried using a wider range including one empty cell above the list, but the result is the same.
    I didn't have this problem before!!
    WHAT IS GOING ON?
    Thanks for your advice.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Advanced filter not working right

    Do you have headers checked? If so, it is using the 1st A as the header.

    If not, check that there are no leading/trailing spaces. test that they are the same using =exact()
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Advanced filter not working right

    You have to make sure that the first row is the header for the column and you have to select all data including header row.
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

  4. #4
    Registered User
    Join Date
    02-10-2010
    Location
    Mexico
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Advanced filter not working right

    I'm not using a header, just trying to filter the list of values.
    Are you both saying I need to have a header in this list and just disregard this header?
    I gotta tell you, I've been filtering lists for some time now, and to do so without a header I just needed to inclued one empty cell above the list to get the unique values right. But I think this stopped working recently.
    If this is the solution then I will include a header from now on.
    I'm just confused because it wasnt like this before.
    Thanks for taking the time to comment

  5. #5
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Advanced filter not working right


  6. #6
    Registered User
    Join Date
    02-10-2010
    Location
    Mexico
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Advanced filter not working right

    Check this out and tell me if this doesn't look odd...
    List the following letters starting in cell A2

    a
    a
    a
    b
    b
    b
    c
    c
    c
    ... use the list range $A$1:$A$10 in the advanced autofillter and the first value (a) will have two instances...
    Now use the same list but now starting in cell A3 and use the list range $A$2:$A$11.... now the first value (a) will only has one instance
    Last edited by Yoden; 08-01-2014 at 12:46 PM.

  7. #7
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Advanced filter not working right

    What Im saying is that if the range has a header, then you need to make sure that heders are checked. If there is no header, then uncheck headers.

    Also, like I said before, check for leading/trailing spaces

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. advanced filter not working
    By reedzhou in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-12-2014, 02:16 AM
  2. Replies: 4
    Last Post: 08-06-2006, 07:45 PM
  3. [SOLVED] Advanced Filter not working
    By babypenquin in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-22-2006, 12:55 PM
  4. Advanced Filter Not Working
    By Cthulhu in forum Excel General
    Replies: 2
    Last Post: 05-10-2005, 03:06 PM
  5. advanced filter not working
    By kwright2 in forum Excel General
    Replies: 1
    Last Post: 03-29-2005, 10:06 AM

Tags for this Thread

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