Find first numer in a Column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
=INDEX(H13:H200,MATCH(TRUE,ISNUMBER(H13:H200),0))

which must be confirmed with control+shift+enter, not just enter.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Last number in Column 1
Finding most recently entered number within a column 3
find first and last in row of numbers 2
Scrabble Value calculation for Welsh words 0
Totaling columns 4
Hide columns based on row values 2
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
How to find a column number using variable criteria? 2

Back
Top