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