C
Colin Sandall
I've come across a problem with advanced filtering in Excel 2003.
If I use an advanced filter on my data, then afterwards apply another filter
using a different criteria, the results are not what they should be. It
only seems to work correctly if the data is in an unfiltered state to begin
with, so I can easily get around it. This problem did not exist in Excel
97.
Has anyone else had the same problem and if so is there a solution to it
other than the one that I know about?
Thanks.
Colin
If I use an advanced filter on my data, then afterwards apply another filter
using a different criteria, the results are not what they should be. It
only seems to work correctly if the data is in an unfiltered state to begin
with, so I can easily get around it. This problem did not exist in Excel
97.
Has anyone else had the same problem and if so is there a solution to it
other than the one that I know about?
Thanks.
Colin