In a column of numbers I need a function to find the last entry

G

Guest

For example I have a column that shows the running balance on a bank account.
I want to find the latest balance which will be on the last populated row of
the spreadsheet
 
B

Bob Phillips

=LOOKUP(2,1/(A1:A10<>""),A1:A10)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 
J

JethroUK©

it's good practise to put total at the top (fixed cell) for these very
reasons - because you have an expanding list doesn't mean you have to keep
re-siting the total
 
G

Guest

Fantastic!
Thanks for your help

Bob Phillips said:
=LOOKUP(2,1/(A1:A10<>""),A1:A10)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
Click to expand...
 

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

Ref in two worksheets 1
Sum if not blank 2
The If function 4
I want a cell to show total from other cell when that cell changes 6
SUMIF FUNCTION works in all cells but those related to one account 4
Function changed 2
Return Last Value in Column 4
Need Help with Sumif Function including dates 6

Top