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?

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?