I have a list of data and some of them are doubled. How can I remove the
double entries? I have tried with an advanced filter and select unique
records only but either I am overlooking something or I am simply to silly to
use it as it does not work. Does anyone know how to get rid of double entries
in a data list within Excel 2003?

Regards

Nicole

Lots of stuff on duplicates at www.cpearson.com
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Nicole" wrote in message
...
I have a list of data and some of them are doubled. How can I remove the
double entries? I have tried with an advanced filter and select unique
records only but either I am overlooking something or I am simply to silly
to
use it as it does not work. Does anyone know how to get rid of double
entries
in a data list within Excel 2003?

Regards

Nicole

Hi Nicole,
You say you tried Advanced Filters, all I can suggest is reading
about it somewhere else. Not knowing what you already read, I would
suggest: Looking at Advanced filters in the Debra's index
http://www.contextures.com/tiptech.html

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Nicole" wrote in message ...
I have a list of data and some of them are doubled. How can I remove the
double entries? I have tried with an advanced filter and select unique
records only but either I am overlooking something or I am simply to silly to
use it as it does not work. Does anyone know how to get rid of double entries
in a data list within Excel 2003?

Regards

Nicole