Small function

  • Thread starter Thread starter Mike
  • Start date Start date
M

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
 
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
 
Back
Top