Small function

[Mike]

Hello All,

Using Windows and Excel XP.

I have a worksheet that will list 25 scores, A1:Y1 and I would like to list
the 3 lowest scores.
In B1 I have the formula =small(A1:Y1,1)
In B 2 I have the formula =smallA1:Y1,2)
In B 3 I have the formula =small(A1:Y1,3)
That would give me the 3 lowest scores in A1:Y1 only if A1:Y1 have a value
listed, otherwise it would give me a zero. How can I find the lowest scores
in A1:Y1 that are NOT blank.

Thank you.

Mike

 

[J.E. McGimpsey]

Hmm...

SMALL() ignores blanks...and text...so what's returing zero?

 

[billQ]

Hi Mike,
Having B1 hold =small(A1:Y1,1) give me a circular function error. The
function is in the same range that it is checking,
bill