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!


--
The Kid
------------------------------------------------------------------------
The Kid's Profile: http://www.excelforum.com/member.php...o&userid=32478
View this thread: http://www.excelforum.com/showthread...hreadid=522660

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



The Kid wrote:
>
> 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!
>
> --
> The Kid
> ------------------------------------------------------------------------
> The Kid's Profile: http://www.excelforum.com/member.php...o&userid=32478
> View this thread: http://www.excelforum.com/showthread...hreadid=522660

--

Dave Peterson

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 :

--
The Ki
-----------------------------------------------------------------------
The Kid's Profile: http://www.excelforum.com/member.php...fo&userid=3247
View this thread: http://www.excelforum.com/showthread.php?threadid=52266