Last number in Column

G

Guest

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

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

Find first numer in a Column 1
Return Each Last Non-blank Cell, Value 2 Column Offset, Many GAPS 1
Last number in a column shows in the total/summay line cell 3
NEED FORMULA TO POINT TO TOP OF COLUMN IF NUMBER GREATER THAN ANOT 9
Sum the last 5 numbers in a column 6
Find the last row using 2 to 20 criteria 8
actual row number 3
row number of last non-blank cell 14

Top