Inverting an advanced filter

[Kevin Lucas]

I'm using the advanced filter and would like to be able to see the set of
rows that are hidden after I've viewed the set of rows that the filter
shows. Some of my criteria are quite complex and converting them to select
the omitted rows only would be time-consuming and, knowing me, error prone.

Is there a way to invert the criteria automatically so I can run the new
filter, or to use the old criteria but then show the hidden rows and hide
the selected rows or is there perhaps some other mechanism to allow me to
see the rows filtered out rather than the rows filtered in please?

Many thanks for any insights you have.

Kevin Lucas

(If replying directly please replace the double 'c' in my email address by a
single 'c').

 

[Debra Dalgleish]

You could add a column to the database, and mark the rows that have been
filtered.

Then, show all the records.
From the marked column, choose (Blanks).

 

[Kevin Lucas]

Excellent. And simple. Thanks. (And great web site by the way. I've used
some of your macros for fixing up Comments after their sizing and
positioning has been wrecked by editing them when rows have been filtered.
And this has given one of my spreadsheets a new lease of life. Great stuff).

Kevin

 

[Debra Dalgleish]

You're welcome, and thanks for letting me know that you like the web site!

Debra