View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] fuchka@gmail.com is offline
external usenet poster
 
Posts: 8
Default first number in cell

Hello

How can I (and can I) .. lookup a range of cell containing different
numbers, and extract number of cell begining with first number ...

example:

11120000
11000000
10000000
11300000
21000000
22000000
23000000
21200000
22200000
51000000
41000000
30000000
31000000
32100000
33300000

So i would like the function to scroll through all this value and then
tell me number of cell beggining with number "1" ... Result: 4


Thnx