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