AUTO FILTER CUSTOMIZATION

Liz_A · Mar 5th, 2002, 12:49 PM

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???

Mark W. · Mar 5th, 2002, 12:56 PM

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 ]

Liz_A · Mar 5th, 2002, 01:05 PM

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

Mark W. · Mar 5th, 2002, 01:07 PM

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

Liz_A · Mar 5th, 2002, 01:08 PM

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?

Mark W. · Mar 5th, 2002, 01:11 PM

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 ]

Liz_A · Mar 5th, 2002, 01:12 PM

Thanks much, Mark

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 5th, 2002, 12:49 PM	#1
Liz_A New Member Join Date: Mar 2002 Posts: 4	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???

Mar 5th, 2002, 12:56 PM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	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 ]

Mar 5th, 2002, 01:05 PM	#3
Liz_A New Member Join Date: Mar 2002 Posts: 4	But is there a way to make sure that the whole colum stays in alphabetical order?

Mar 5th, 2002, 01:07 PM	#4
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Filtering doesn't disturb the pre-existing order of the rows. It merely displays the relevant ones.

Mar 5th, 2002, 01:08 PM	#5
Liz_A New Member Join Date: Mar 2002 Posts: 4	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?

Mar 5th, 2002, 01:11 PM	#6
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	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 ]

Mar 5th, 2002, 01:12 PM	#7
Liz_A New Member Join Date: Mar 2002 Posts: 4	Thanks much, Mark