Filtering using ends with decimal criteria

T

tmj

I am trying to filter a list to show only rows that contain a number
ending in a specific digit. The problem I've encountered is the
numbers have 2 deciaml places and I cannot determine how to set the
criteria.

For example, the numbers are 9.99, 1.49, 2.73, 4.56, 7.31, 1.89 -- I
want to only view those rows that contain data ending with the .*9 --
how can I do this?
 
B

Bob Phillips

Add a helper column, formula

=RIGHT(A2,1)="9"

and filter this column for TRUE.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Top