Saved Filters
Comments
-
My experience is you have to sort your rows first, then apply your filter.
-
Filters will not resort the rows when selected. They will only filter the results in the current sorted rows.
Craig
-
I thought that was the case but even when I sort alphabetically it isn't correct. It basically breaks the sheet up into 2 sections of A-Z.
For instance, it will list my rows A-Z and then start a new A-Z under the 1st set. It won't take all rows and make then A-Z from row 1 to the end.
-
Thanks Craig,
One other question - when I turn on my filter it will say 71 out of 73 rows filtered. Is there a way to see which rows weren't filtered?
-
To create a "unfiltered" list, you need to create a second filter.
I often have a "Late" and a "Not Late" set of filters if it comes up enough.
Craig