removing duplicate records in excel, how to do it? in Excel General Questions  
 |  Edit my Profile  |  Help
 
     
   
 
 
 
Don 12/15/2004 7:57 AM PST
  Question
  How to remove duplicart entries within excel?
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Peo Sjoblom  12/15/2004 8:05 AM PST
  Answer
  Data>advanced filter, unique records only

Regards,

Peo Sjoblom

"Don" wrote:

> How to remove duplicart entries within excel?
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Art Sarno 7/26/2005 5:44 PM PST
   
  Have you notice that the first entry is duplicated in both cases: when header
line is included or exclude

"Peo Sjoblom" wrote:

> Data>advanced filter, unique records only
>
> Regards,
>
> Peo Sjoblom
>
> "Don" wrote:
>
> > How to remove duplicart entries within excel?
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Frank Kabel 12/15/2004 8:11 AM PST
   
  Hi
see:
http://www.cpearson.com/excel/deleting.htm#DeleteDuplicateRows

--
Regards
Frank Kabel
Frankfurt, Germany

Don wrote:
> How to remove duplicart entries within excel?


 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
  Return to Microsoft Communities  Notify me of replies