|
Posted to microsoft.public.excel.misc
|
|
|
return last cell in a row not zero
=LOOKUP(2,1/(1:1<0),1:1)
"Maarkr" wrote:
hopefully simple but im an access type... and I would like a formula, not vb
code. a price is entered each week, starting from the left, default $0 if
not filled in. I want to return the first nonzero value from the right.
After 4 weeks i t looks like:
15 25 35 25 0 0 0 0 0
I want to return 25.
|