Hi again,

Am Tue, 19 Nov 2013 11:45:56 -0800 (PST) schrieb GWC:

I did what you suggested and it's taking 30 minutes and counting.

if you use xl2007 or later you can also try it via Data = Remove
duplicates.
Or (with all versions) you can filter with advanced filter without
duplicates to another column.


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2