Multiple Filters in 1 worsheet?

H

Hickeym

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
 
H

Hickeym

Nick,

Maybe it is the version I am using, Excel 202 SP3, but I can only filter all
columns or none. It does not allow me to filter each column individually.
Any suggestions?
 
D

Dave Peterson

You get one range to filter per worksheet.

But that range can have multiple columns.

Turn of the autofilter (to start fresh)

Select your range to filter--(say A1:X9999)

Then apply data|Filter|autofilter.

You'll see dropdown arrows in the top row of that selected area of each cell.
 
H

Hickeym

Dave,

Thanks for the input. I guess this can't be done the way I was hoping. I
was hoping to be able to filter multiple times in the same worksheet in
different columns.
 
D

Dave Peterson

If/when you upgrade to xl2003, you might be able to use Data|List to give the
effect that you want.
 
H

Hickeym

Thank you again - I will look into Excell 2003.

Dave Peterson said:
If/when you upgrade to xl2003, you might be able to use Data|List to give the
effect that you want.
Click to expand...
 
Y

youngster

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?

Hickeym said:
Thank you again - I will look into Excell 2003.
Click to expand...
 
D

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.
 
Top