MrExcel Publishing
Your One Stop for Excel Tips & Solutions

identical cells


Posted by Tom Vandoorne on October 26, 2001 5:02 AM

When using an Excel-sheet as the source file for a mail-merge, how can I automatically find / delete the double or identical records in the file?


Posted by Bob Umlas on October 26, 2001 5:04 AM

Can you use Data/Filter/Advanced filter and select the unique values only checkbox? You'd need a particular column to do this easily, or a more involved formula to do this NOT-easily.

Posted by Tom Vandoorne on October 26, 2001 5:18 AM

Thanks Bob!!! It is really that simple indeed! I think I'll be back on this site.

Tom

Posted by Tom Vandoorne on October 26, 2001 5:18 AM

Thanks Bob!!! It is really that simple indeed! I think I'll be back on this site.

Tom

Posted by Tom Vandoorne on October 26, 2001 5:23 AM

Thanks Bob!!! It is really that simple indeed! I think I'll be back on this site.

Tom