Custom filters

[Guest]

I would like to create a rule in a column that will filter out every value
ending in '99'. The regular Excel filters will allow me to filters out
particular occurences eg. ABCD99, BCDE99, but not everthing ending in 99
(there are too many to it manually).

Is it possible to create a custom filter along these lines?

Thanks in advance.

 

[Guest]

Just sussed it for myself.
Thanks.

 

[David Biddulph]

Just sussed it for myself.
Thanks.

Thanks for letting us know that you've found the answer, but in doing so it
might be handy if you let other readers know the answer in case they have
similar questions.

I guess that you may have found the AutoFilter Custom option and used "does
not end with" 99? Had you spotted that if you have a number in there rather
than text, if it ends in 99 it evades the filter? Have you found a way
round that?

 

[Dave Peterson]

Maybe you could use a helper column that extracts that last two characters:

=right(a2,2)

or even make the helper column text:

=a2&""

Then use that to display the rows you want.