Problem with SMALL Function

Giganews Newsgroups
Subject: Problem with SMALL Function
Posted by:  ryanhannasmi…@gmail.com
Date: 5 Jan 2007

I am having a problem with the SMALL function in Excel.  I've written a
simplified example of the problem I'm having:

Example
      A
1  10
2  20
3  30
4  60
5  25
6  12

When I use the =SMALL(A1:A6,1) the function returns 10
When I use the =SMALL(A1:A6,2) the function returns 10 ** this should
be 12 **
When I use the =SMALL(A1:A6,3) the function returns 12 ** this should
be 25 **

Any thoughts??

Thanks in advance,
Ryan

Replies