Retrieving last actual value in a list
Many thanks - works perfectly
"FSt1" wrote:
hi
=OFFSET(A2,COUNTIF(A2:A100,"0")-1,0)
Regards
FSt1
"jonny" wrote:
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
|