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?