D
Daveo
I have a row of data with either zeros or numbers in 24 cells. I would like
to create a formula in an adjacent cell which scans the 24 cells and records
the first nonzero number it finds.
I've thought of using a nested if-then but that seems to cumbersome. Would
appreciate your feedback...thx.
Daveo
to create a formula in an adjacent cell which scans the 24 cells and records
the first nonzero number it finds.
I've thought of using a nested if-then but that seems to cumbersome. Would
appreciate your feedback...thx.
Daveo