| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to create ranges with auto filter
Hi,
I would like to find out if it is possible to create ranges with auto filter. An example would be I have a whole list of prices and so when I use auto filter, it gives me the entire list of prices too. But I want users to be able to choose from ranges such as 100-200, 201-300, 301-400 etc. And after that auto filter will filter out the prices within the range chose by the user. Is this possible? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to create ranges with auto filter
Hi
you could use 'Custom' from the autofilter drop down for this -- Regards Frank Kabel Frankfurt, Germany Ivy Chua wrote: Hi, I would like to find out if it is possible to create ranges with auto filter. An example would be I have a whole list of prices and so when I use auto filter, it gives me the entire list of prices too. But I want users to be able to choose from ranges such as 100-200, 201-300, 301-400 etc. And after that auto filter will filter out the prices within the range chose by the user. Is this possible? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| DataFilterAuto Filter in excel 2007? | New Users to Excel | |||
| Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
| Excel auto filter doesn't recoginize case - won't filter AA from A | Excel Discussion (Misc queries) | |||
| How do I auto-filter multiple ranges on one worksheet? | Excel Worksheet Functions | |||
| Multiple ranges to Auto Filter | Excel Programming | |||
Linear Mode
