Use SMALL function

**excelhelp456** · 06-23-2009, 02:04 PM

I'd like to use the SMALL() function in excel to pull out the second lowest unique value in a list, but I'm not sure there is a way to do this.

For example, if the array is {1,1,3,10,2,6}, then SMALL(array,2) returns 1, but I'd like it to return 2.

Is there a way I can modify this function or use a different one to achieve what I want?

Any help would be *greatly* appreciated. Thanks.

**shg** · 06-23-2009, 02:10 PM

Welcome to the forum.

=SMALL(A1:A6, COUNTIF(A1:A6, MIN(A1:A6)) + 1)

**JBeaucaire** · 06-23-2009, 02:12 PM

Try this array formula, adjust the cell range for your data, and press CTRL-SHIFT-ENTER to confirm the array:

=SMALL(IF(A1:A6>SMALL(A1:A6,1),A1:A6,""),1)