Excel 2007 : Take last number of list

[pansovic]

Is there a formula that I always can take the last number of a list? Regularly I add numbers to column A and I want that in B1 always apears the last number. So when I add a number in A2 B1 should take the number in A2 and when I add a new number in A3, B1 should be same as A3, etc

[Cutter]

You could use:

=INDEX(A:A,COUNT(A:A),1)

assuming you have only numbers and no blank cells between entries.

[MarvinP]

Find the attached with a Dynamic Named Range that will count non empty cells in column A. Then using this number of rows does an indirect to give the value of the last entry in B1.

Please Login or Register  to view this content.

The named range of

Please Login or Register  to view this content.

Hope this helps.