Jane,

assuming the source data is in A1:A20

In B1: =A1
In
B2:=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)))

B2 is an array bormula, so commit with Ctrl-Shift-Enter, and copy B2 down as
far as you need

--

HTH

RP
(remove nothere from the email address if mailing direct)


"JaneC" wrote in 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