Formula to list unique values
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
|