Hello,
I have 3 columns in a range and need to return to another cell on each row the lowest number not equal to zero. at least one number on each row is zero and a lot have two zeroes. The problem is using =small(j3:l3,2) returns a zero in the cases where two cells in the range equal 0.
Please advise the formula to return the smallest number not equal to zero.
sample data
j K L
$57.87 0 0
$151.50 0 0
$ 0 1.35 1.09
$ 0 80.64 75.00
Thank you
Bookmarks