Performing two Advanced Filters in the same sheet

[Neal]

Dear experts,

I have a range that I am using the Advanced Filter to hide
amounts less than 0. On the same worksheet, further down,
I have a different range that I want to use the Advanced
Filter to hide amounts less than 5. Each of these ranges
feeds a different chart. When I use the Advanced Filter
on the second range, the first range shows all the data.
Is there a way around this? Can I use Advanced Filter for
each different range on the same worksheet and if so, how?

Thanks in advance,

Neal

 

[Peo Sjoblom]

You can copy the filtered data to another location in one fell swoop, assume
the table is in A2:B200 in Sheet1,
do the filtering but check copy to another location and put the filtered
data there, then change the criteria to >=5
and repeat but select another location to copy it to,that will give you 2
filtered tables that you can chart on

 

[Debra Dalgleish]

You can have only one filter per worksheet. Move one of the tables to a
different sheet, and your filters and charts should work properly.