AUTO FILTER CUSTOMIZATION

Liz_A

New Member
Joined
Mar 4, 2002
Messages
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???
 

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.
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
 
Upvote 0
Filtering doesn't disturb the pre-existing order of the rows. It merely displays the relevant ones.
 
Upvote 0
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?
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,213,492
Messages
6,113,967
Members
448,537
Latest member
Et_Cetera

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top