- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel
- 2007 January
- Problem with SMALL Function

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

- Re: Problem with SMALL Function posted by JE McGimpsey on Fri, 05 Jan 2007