Multiple Filters in 1 worsheet?

[Guest]

G'day,

I have been told that you can filter multiple columns. For example, if in
column A I have facilities listed, and in column B days are listed, you can
filter seprately. Meaning that I should not have to list each facility for
each day when I filter. I would like to have up to 15 different filters in
the same worksheet if possible.

My questions is, "How do you do this...?"

Thanks

 

[Nick Hodge]

Just highlight the top row of the data and go to Data>Filter>Autofilter and
then filter each column you need using the drop down arrows at the top

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)

 

[Guest]

The macro works for me in hiding unwanted filter arrows, but when I use a
filter I'm getting a few columns from the bottom of my spreadsheet in the
results, even though they don't contain the filter criteria.
Is this a range issue in my auto filters?

Thank you again - I will look into Excell 2003.

 

[Dave Peterson]

I don't see any macro code in the quoted text.

But if you're getting rows that aren't being filtered, I'd guess that your
filtered range doesn't include those rows.

Remove the filter (data|filter|autofilter)
Then select all the range first--don't let excel guess at the range.

Then do data|filter|autofilter and try it once more.