HOW TO RETRIEVE THE LAST VALUE IN A COLUMN

Suppose the data is laid as shown in the below image

The formula in cell B1 is

=INDEX(A:A,COUNTA(A:A))

this will retrieve the value in the last cell of column A.

but the above formula will fail if the there are blank in the column A this can modified as follows:

the formula in cell B1 is

=INDEX(A:A,MAX(ROW(A:A)*(A:A<>””)))

so if there are blanks in between data the above formula is written to ignore those black.

Advertisements