I am trying to get excel to identify the last numerical value in a column,
but depending on data fed in the last value may be in a different row wihtn
a column. For example in one instance the last value may be A3. In another
A5, in another A6 etc. Does anyone know the formula that I would put in
another cell to return the value of the last cell in column A that actually
has a value. Many thanks in advance.

Jonny