MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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

Re: See: http://www.mrexcel.com/tip008.shtml for a solution. [NT]

posted by Aladin Akyurek on November 26, 2001 at 14:38:57:

Thanks Aladin

Posted by on