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?