Hi,

Am Mon, 8 Jul 2013 11:41:13 +0100 schrieb DConstance:

In column A I enter purchase order numbers, in B part numbers and
descriptions in C. I need to copy the data in columns B and C without
the duplicates. I have many duplicates in B and C due to having the same
part numbers/descriptions on various purchase orders. I'm going to
continue adding data to these 3 columns. I haven't successfully created
a formula to copy the contents of columns B and C without the
duplicates. Any ideas?

try advanced filter without duplicates.


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