Small/Large formula

[MOB]

If I have data such as this;

25
26
32
25
27
31

If I use the formula =small(A1:A6,2) it returns 25

Is there a formula I can use that would return 26 instead? ie second smallest unique number.

TIA

 

[MOB]

Does this help:

25	26
26
32
27
31
25

<TBODY>
</TBODY>

B1:
=SMALL(A1:A8,COUNTIF(A1:A8,MIN(A1:A8))+1)

Perfect thanks

Thanks to both of you for your help!

 

[Robert Mika]

Perfect thanks

Thanks to both of you for your help!

Welcome.
Thanks for feedback