Filtering using ends with decimal criteria

  • Thread starter Thread starter tmj
  • Start date Start date
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?
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Select rows which satisfy 2 criteria 16
VBA: How can I use a string variable as autofilter criteria? 4
data return using multiple conditions 8
Advanced Filter - Exclude two criteria in separate columns 2
SUMIF with criteria "<>" & "=" 4
Copying a Filter list to a new worksheet. 1
Counting rows that meet multiple criteria 5
Count Advanced Filtered Rows 3

Back
Top