Compare and copy unique values

S

sa02000

I have few different excel files and they all have list of part number
in column A. Each list has thousands of rows. These lists in differen
files may have common parts among them (and a given part numbers coul
be in more than 2 lists) as well as unique parts. I would like t
somehow (either through macro or some function) compare all the list
and copy all part numbers once in another separate excel file. Doe
anyone have any idea how to approach this or does someone have
function/macro that can do this?

Thank you very much to this community in advance.
Ja
 
G

Guest

Hi Jay,

one way to do it is by Pivot table, you can copy all information in one new
worksheet, and use a pivot table to get all part numbers not considering
duplicates

hope this help,
regards from Brazil going to the 6th
Marcelo

"sa02000" escreveu:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sort unique data from a colum 2
Lookup and Display Multiple Unique values based on criteria 7
FINDING AND LISTING UNIQUE DATA IN A COLUMN 3
Excel - Compare spreadsheets and indicate matched data 4
Count Unique accross mulitple columns 3
countif - unique values only 8
Unique count is criteria is met 1
Compare two lists 1

Top