Look at the SMALL worksheet function.

--
Jim
"Ken" wrote in message
...
| 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
|
|