A
Anto111
Hi Guys,
I need to find the last value within a column range that is greater than zero.
For example, Within A1:A8 I have values of 1,0,3,5,6,0,0,0 I therefore need
excel to recognise the number 6 and ignore the subsequent 3 zero's.
I also need this to update with new data, so for example If A9 is zero then
continue to recognise the last value as 6, but if A9 is 2 then recognise the
most recent value as 2.
Sorry if the example is not clear.
Kind regards,
Ant
I need to find the last value within a column range that is greater than zero.
For example, Within A1:A8 I have values of 1,0,3,5,6,0,0,0 I therefore need
excel to recognise the number 6 and ignore the subsequent 3 zero's.
I also need this to update with new data, so for example If A9 is zero then
continue to recognise the last value as 6, but if A9 is 2 then recognise the
most recent value as 2.
Sorry if the example is not clear.
Kind regards,
Ant