View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tmj
 
Posts: n/a
Default Filtering using ends with decimal criteria

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?