Results 1 to 5 of 5

Autofilter a list.

This is a discussion on Autofilter a list. within the Excel Questions forums, part of the Question Forums category; Basic Excel Question here: I want to create a list of peoples names and then filter it so that one ...

  1. #1
    New Member
    Join Date
    Jun 2004
    Location
    Tampa, FL
    Posts
    3

    Default Autofilter a list.

    Basic Excel Question here:
    I want to create a list of peoples names and then filter it so that one persons name can be selected from that list. When I create the list and then autofilter I get a dropdown box showing my list of names and "all, top 10, custom". However, when I choose a name out of the list it does not get filtered out.
    So, if my list were "Amy, Becky, Cathy, Dave" and I select "Dave" what iI see is that "Amy" is still at the top of the list and "Dave" appears below "Amy". How do I fix this?[/list][/list]

  2. #2
    Board Regular
    Join Date
    May 2004
    Location
    Bangalore
    Posts
    162

    Default Re: Autofilter a list.

    Are you creating a List from Menu Data>Validation, or you are Doing Data filter using Menu Data>Filter > Auto Filter?

    Regards,
    Yeheya

  3. #3
    New Member
    Join Date
    Jun 2004
    Location
    Tampa, FL
    Posts
    3

    Default

    I am doing the Menu Data>Filter>Autofilter.

    Thanks

  4. #4
    Board Regular
    Join Date
    May 2004
    Location
    Bangalore
    Posts
    162

    Default Re: Autofilter a list.

    Do have any blank rows in between your data?

    If yes, check you work after removing the blank rows.
    (To remove blanks rows in this case: Sort your data on key column)

    Regards,
    Yeheya

  5. #5
    New Member
    Join Date
    Jun 2004
    Location
    Tampa, FL
    Posts
    3

    Default

    Okay..I figured it out. I can filter using the Valdiation now and the list works. Thanks so much for your help, Yeheya!

    Rox

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com