Well, if you have 3 values that happen to be the minumum, those are
the 3 smallest values - you will find the next largest value with a
parameter of 4, so instead of using a specific number you can use
COUNTIF for the smallest number and then add 1 onto it, something like
this:

=SMALL(A1:A10,COUNTIF(A1:A10,SMALL(A1:A10,1))+1)

This will find the second smallest numerical value in A1:A10, even if
you have several that are equal to the minimum.

Hope this helps.

Pete

On Apr 10, 3:12*pm, Ken wrote:
Issue with SMALL Function is ... when MIN Value randomly Repeats SMALL
Function returns MIN Value.

Thanks ... Kha



"Pete_UK" wrote:
Use the SMALL function, with a parameter of 2 to get the second
smallest - XL Help describes it well.

Hope this helps.

Pete

On Apr 9, 1:01 pm, Ken wrote:
Excel2003

I have a list of values (approx 30) of which some may repeat.

I wish to set cell pattern of "next to lowest" value.

=MIN(myrange) will set cell pattern containing lowest value, but I need to
be 1 click up from MIN value ... (I need to set cell pattern of "next to
lowest" value(s)).

Solutions? ... Thanks ... Kha- Hide quoted text -

- Show quoted text -