View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Biff
 
Posts: n/a
Default Find all numbers in database that end in...

Hi!

end in .00
ending in 00.00
(example: 5,400, 600, 72,300)


Based on your example how many meet either criteria? I don't see any!

Biff

"eschaet" wrote in
message ...

I have a database of numbers. I would like to be able to find all of
the numbers within the database (or range) that end in .00. I may also
need to find all numbers ending in 00.00 (example: 5,400, 600, 72,300).
Any help will be appreciated. Thanks


--
eschaet
------------------------------------------------------------------------
eschaet's Profile:
http://www.excelforum.com/member.php...o&userid=33924
View this thread: http://www.excelforum.com/showthread...hreadid=537007