View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
OX_Gambit OX_Gambit is offline
external usenet poster
 
Posts: 9
Default Formula to find the last number in a series

Hello,

I have the following list of number and need to find the last number that
starts with 1006? How do I do that? Also if I search for numbers beginning
with 1008 I need to know that there is none present.

1005001
1005002
1006001
1006002
1006003
1007001
1007002