View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Aladin Akyurek
 
Posts: n/a
Default Find first numer in a Column

=INDEX(H13:H200,MATCH(TRUE,ISNUMBER(H13:H200),0))

which must be confirmed with control+shift+enter, not just enter.

Two-Canucks wrote:
In a spreadsheet Column H is filled randomly
with numbers and blanks from Row 13 down.
I want to find the first number i.e. occurring in
the lowest row number in the Column.
Preferably found by worksheet formula, failing that
I could use a macro.
Many thanks for any solutions.