Data / Filter / Advanced Filter / 'Copy to another location' and 'Unique values
only'
Then replace original list with new list
--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03
----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------
"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
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (
http://www.grisoft.com).
Version: 6.0.808 / Virus Database: 550 - Release Date: 09/12/2004