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

C

Charlie Bamford

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
 
C

Charlie Bamford

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

Check register with running balance 0
Ref in two worksheets 5
Excel - Wich Function should I use? 1
First row where a cell is zero 2
Need Help with a VBA subroutine 0
Multi-demensional frequency distribution 4
The If function 4
Sum if not blank 2

Top