G
Guest
I am trying to find the last entered value in a list of basic weight data. I
enter new numeric values to the list on a daily basis, but would like to
always show the last entered value in another cell also. The list also
contains zero values, that I want to exclude or ignore from my result, e.g.
0
300
250
350
375
0
0
would always return 375, as the last value in the list (which will also
always be positive) it's also the VALUE I need, not the position in the list.
Regards,
IvanM
enter new numeric values to the list on a daily basis, but would like to
always show the last entered value in another cell also. The list also
contains zero values, that I want to exclude or ignore from my result, e.g.
0
300
250
350
375
0
0
would always return 375, as the last value in the list (which will also
always be positive) it's also the VALUE I need, not the position in the list.
Regards,
IvanM