Filtering using ends with decimal criteria

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

tmj - 20 Jun 2006 11:35 GMT

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?

Reply to this Message

Bob Phillips - 20 Jun 2006 12:04 GMT

Add a helper column, formula

=RIGHT(A2,1)="9"

and filter this column for TRUE.

Signature

HTH

Bob Phillips

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

> 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
[quoted text clipped - 4 lines]
> want to only view those rows that contain data ending with the .*9 --
> how can I do this?

Reply to this Message