Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 7 of 7

Thread: AUTO FILTER CUSTOMIZATION

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    How can I customize the autofilter? I am trying to make a spreadsheet of people for this volunteer program, so i want to have one column with their last name, then first, and then who they are assigned to. I want them to be able to search in the "last name" category alphabetically, and then by the specific group they are assigned to, like all the people in Orange group, etc... Any ideas???

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    If I understood correctly your Name column consists of Last, First...

    If so, use a Custom AutoFilter on this column with "begins with" and the 1st letter of the last name of interest.

    [ This Message was edited by: Mark W. on 2002-03-05 11:57 ]

  3. #3
    New Member
    Join Date
    Mar 2002
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    But is there a way to make sure that the whole colum stays in alphabetical order?

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Filtering doesn't disturb the pre-existing order of the rows. It merely displays the relevant ones.

  5. #5
    New Member
    Join Date
    Mar 2002
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Ok, so essentially i need to just type them in in alphabetical order, and then just worry about the filering for the rows of what "Group" they are assigned to, in order to show all the people in group "A" or all the people in group "B"...Correct?

  6. #6
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Essentially, yes. But, you don't have to type them in alphabetical order. Just type 'em in and the use Excel's Data | Sort... menu command to re-order 'em.

    You can also use my suggestion above to show all the W's in group A.

    [ This Message was edited by: Mark W. on 2002-03-05 12:12 ]

  7. #7
    New Member
    Join Date
    Mar 2002
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks much, Mark

Some videos you may like

User Tag List

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
  •