A
ACEACE
That is the bottom-most non-zero number?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Biff
C
CLR
That seems to return only the value in A10.........
Perhaps this........
=SMALL(A1:A10,COUNTIF(A1:A10,0)+1)
Vaya con Dios,
Chuck, CABGx3
Perhaps this........
=SMALL(A1:A10,COUNTIF(A1:A10,0)+1)
Vaya con Dios,
Chuck, CABGx3
B
Biff
C
CLR
My apology.......I kept reading "the bottom-most non-zero number" as being
"the smallest non-zero number".........
Vaya con Dios,
Chuck, CABGx3
"the smallest non-zero number".........
Vaya con Dios,
Chuck, CABGx3