In B1 enter:
=A1
In B2 enter:
=IF(ISERROR(MATCH(0,COUNTIF(B$1:B1,$A$1:$A$20&""), 0)),"",INDEX(IF(ISBLANK($A$1:$A$20),"",$A$1:$A$20) ,MATCH(0,COUNTIF(B$1:B1,$A$1:$A$20&""),0)))

as an array formula (CNTRL-SHIFT-ENTER0

copy B2 down as far as you need

--
Gary''s Student - gsnu200726


"momtoaj" wrote:

I have a list that is going to constantly be changing. One time the list may
have 185 records & next time the list might have 18,212 records. I need to
evaluate the values in a column & return a list of only the unique values in
the column !!!without using filters, pivot tables or any menu items - it has
to be formulas or arrays ONLY because my users wouldn't know how to handle
the pivot tables or follow directions from the menu!!!

For example...

3.03
3.03
3.5
3.57
3.99
3.99
3.99
4.0
4.0
4.1
4.3
4.33

The result would be:

3.03
3.5
3.57
3.99
4.0
4.1
4.3
4.33