close
I'm looking for a way of selecting the 2nd or 3rd smallest value in a range
of data, not just the min.
Hi!
=SMALL(A1:A10,1) is the same as =MIN(A1:A10)
2nd smallest: =SMALL(A1:A10,2)
3rd smallest: =SMALL(A1:A10,3)
etc
Biff
quot;jd110110quot; gt; wrote in message
...
gt; I'm looking for a way of selecting the 2nd or 3rd smallest value in a
gt; range
gt; of data, not just the min.
全站熱搜
留言列表
