HOW TO RETRIEVE THE LAST VALUE IN A COLUMN
April 2, 2012 Leave a comment
Suppose the data is laid as shown in the below image
The formula in cell B1 is
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
so if there are blanks in between data the above formula is written to ignore those black.