If your data set were in A1:A10, place this in B1, press
ctrl/shift/enter, and fill down until you receive errors.

=INDEX($A$1:$A$10,SMALL(IF(ROW($A$1:$A$10)=MATCH
($A$1:$A$10,$A$1:$A$10,0),ROW($A$1:$A$10)),ROW()))

HTH
Jason
Atlanta, GA

-----Original Message-----
Hi,

I have the below list of values:

1
1
1
2
2
3
4
6
6

What I want to do is show a list of the unique values
ie. Get rid of the
repeated values and only show one of each, so that the
list looks as follows:

1
2
3
4
6

Can anybody please tell me how I can do this without
manually going through
and deleting the repeated values??? I am using Excel 2003

Thanks!

JaneC

.