Removing duplicate entries?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

The Kid - 15 Mar 2006 16:36 GMT

Forum,
Is there a quick way to remove duplicate entries in my document? I am
cutting and pasting dates into excel, and I have 859 entries so far.
The problem is that many of them are identical. Is there a way to have
excel remove the duplicates so only one remains? I've tried the "filter
for unique records" method that the Microsoft Office Assistance said to
do, to no avail.
Thanks in advance!

Signature

The Kid

Reply to this Message

Dave Peterson - 15 Mar 2006 17:19 GMT

I read Debra Dalgleish's instructions:
http://www.contextures.com/xladvfilter01.html#FilterUR

or Chip Pearson has some techniques at:
http://www.cpearson.com/excel/duplicat.htm

> Forum,
> Is there a quick way to remove duplicate entries in my document? I am
[quoted text clipped - 10 lines]
> The Kid's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=32478
> View this thread: http://www.excelforum.com/showthread.php?threadid=522660

Signature

Dave Peterson

Reply to this Message

The Kid - 16 Mar 2006 18:16 GMT

Thanks Dave. I found both web pages and am working my way through it.
It's a little above my head, but I'll get there!
Thanks again for the info :

Reply to this Message