Multiple filters in same column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have a worksheet which contains different sections of data, on which I
would like to filter. The problem is, the data I'm interested in, is all
contained in the same column (has to be like this.) I would like the ability
(for example) to sort A1-A20, A30-A38, A45-A54...(each section having it's
own drop down filter list.) Is this possible?

Thanks,
Mark O
 
You only get one data|filter|autofilter per worksheet. It can have lots of
columns--but only one range can be filtered at any time.

But if you're running xl2003, you may find Data|List a nice option.
 
Data|List was added in xl2003.

Select your first range and do Data|List.
Select the second range and do Data|List.
and so forth.

If you don't use xl2003, then this option doesn't exist.
 
Back
Top