DConstance Wrote in message:

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?

I think there is no Chance to do this by formula only.
After copying by formula you will have to remove duplicates by the
menufunction in menu's "Data" section
I suppose, dringend this by VBA would bei mich easyer
--