Hi,

Put this in b1 =MIN(A1:A10)

then put this in b2 and enter as an array (see below for array instructions)
and drag down until the formula produces zero. Important you must array enter
BEFORE dragging down.

=MIN(IF($A$1:$A$10B1,$A$1:$A$10))

This is an array formula which must be entered by pressing CTRL+Shift+Enter
'and not just Enter. If you do it correctly then Excel will put curly brackets
'around the formula {}. You can't type these yourself. If you edit the formula
'you must enter it again with CTRL+Shift+Enter.


Mike

"Basketball" wrote:

Using the small function, is there a way with one formula to get a
list of unique small values.
If I had the following:
1
1
2
4
4
6
9
11
11
13

If I look up =small(a1:10,1) it gives me 1
If I look up =small(a1:10,2) it gives me 1

What I am looking for is a formula that will give me
1
2
4
6
9
11
13

Any help would be appreciated! Thanks in advance!