display last entry in Excel

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

Guest

I have created a column that calculates the running total, and i would like
Excel to use only the last value in the list. however, when a new value is
added to the bottom of the list, excel will then take that entry.

Can anybody help. Thanks
 
Ayedeeh

If the data is contiguous, (say in column A), you could use this

=INDIRECT("A"&COUNTA(A:A))

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
What if the list is not continuous, or if i display "zero values", can i get
it to display the last entry greater than 1?
 
ayedeeh

I used contiguous, not continuous, that is, there is no gaps in the data.
0's work fine

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
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

Help needed 0
How to create a bubble chart with more than 2 variables 0
VBA - retrieve data on last create named range from previous inserted named range 0
Offset and Small functions with blank rows? 0
Excel Stop Excel from displaying rounded values 4
MS Access Sub form display with all entries 1
Counting multiple memberships 1
Excel VBA - counting cells by colors and names to it in two different rows. 0

Back
Top