Saved Filters

shornbuckle · 08/09/18

I'm trying to put together a saved filter and I would like to have one of my filters sort alphabetical. Is this possible?

Thanks!

Joy Durham · 08/09/18

My experience is you have to sort your rows first, then apply your filter.

J. Craig Williams · 08/09/18

Filters will not resort the rows when selected. They will only filter the results in the current sorted rows.

Craig

shornbuckle · 08/10/18

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.

shornbuckle · 08/10/18

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?

J. Craig Williams · 08/10/18

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

Comments