Forum Discussion
Solved
Last number in a series?
Hi, I have a column of numbers that get's added to every day. I need a formula to return me the last number in the series please? Thanks in advance
As an alternative:
=INDEX(A:A,AGGREGATE(14,6,(ROW(A:A)*NOT(ISBLANK(A:A))),1),1)This one allows for blank cells and it doesn't matter if you have a header or not. It returns the value of the last cell in the column that is NOT blank.
As an alternative:
=INDEX(A:A,AGGREGATE(14,6,(ROW(A:A)*NOT(ISBLANK(A:A))),1),1)This one allows for blank cells and it doesn't matter if you have a header or not. It returns the value of the last cell in the column that is NOT blank.
thank you very much