Excel formula re: last entry

[pehl]

Hi everyone,
Help please...I know this should be simple.
I need to report only the LAST value entered in a column on a different worksheet, ignoring values in cells above and ignoring blank cells following.
Thank you,
pe

[Jacob Hilderbrand]

If the column of data is A then try this formula.


=INDIRECT("A" & MATCH(9.99999999999999E+307,A:A,TRUE))

[Zack Barresse]

Hi pehl, welcome!

Another alternative could be ...



=INDEX(A:A,MATCH(9.999999999E+307,A:A))


This doens't use the INDIRECT function like Jacob's and can be copied over columns. Depends on your situation, but it's an alternative.

[pehl]

I kept getting a circular reference with the INDIRECT function but the INDEX function works--thank you so much!

pehl