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
.
|