In a cell on row 5 enter =--RIGHT(A5,2)
Put a name (TEST) in the top row
Select all the data including the top row with names and filter
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Margo Guda" wrote in message
...
I have a very large database where I want to filter out numbers that do not
have certain two digits as their last two. For example, the column based on
which I want to filter out data contains numbers like 197301310153. I want
to filter out anything that does not end in 53.
I tried using a criterium with a formula such as
=RIGHT(TEXT(A5,"###########"),2)="53", where A5 contains the first record
of the database. I put this criterium in A2, and when I select the
advanced filter from the menu I make sure it does not look for a column
label, i.e. the criterium only refers to this cell A2. But this does not
filter out anything. Can anyone here help me?
Thanks in advance.

Margo Guda.