Performing two Advanced Filters in the same sheet

  • Thread starter Thread starter Neal
  • Start date Start date
N

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