Archive of Mr Excel Message Board

Back to Data in Excel archive index
Back to archive home

Add new entries to a list, duplicates not added
Posted by Frank Krumm on November 26, 2001 2:31 PM
I have a long columnar list in alphabetic order. Each day I add new entries. Some of the entries are new, some are already in the list.
The new I would like to keep, the duplicates no.
I have been trying to use the EXACT function, but I'm flailing.
Help please!

Posted by Frank Krumm on November 26, 2001 2:46 PM
posted by Aladin Akyurek on November 26, 2001 at 14:38:57:
Thanks Aladin

Posted by on

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our
online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.