Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Compare and copy unique values
I have few different excel files and they all have list of part numbers in column A. Each list has thousands of rows. These lists in different files may have common parts among them (and a given part numbers could be in more than 2 lists) as well as unique parts. I would like to somehow (either through macro or some function) compare all the lists and copy all part numbers once in another separate excel file. Does anyone have any idea how to approach this or does someone have a function/macro that can do this? Thank you very much to this community in advance. Jay -- sa02000 ------------------------------------------------------------------------ sa02000's Profile: http://www.excelforum.com/member.php...o&userid=27747 View this thread: http://www.excelforum.com/showthread...hreadid=551190 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Compare and copy unique values
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: I have few different excel files and they all have list of part numbers in column A. Each list has thousands of rows. These lists in different files may have common parts among them (and a given part numbers could be in more than 2 lists) as well as unique parts. I would like to somehow (either through macro or some function) compare all the lists and copy all part numbers once in another separate excel file. Does anyone have any idea how to approach this or does someone have a function/macro that can do this? Thank you very much to this community in advance. Jay -- sa02000 ------------------------------------------------------------------------ sa02000's Profile: http://www.excelforum.com/member.php...o&userid=27747 View this thread: http://www.excelforum.com/showthread...hreadid=551190 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compare name and copy from closed .csv files | Excel Worksheet Functions | |||
Compare two Sheets and copy value | Excel Worksheet Functions | |||
compare values and replace | New Users to Excel | |||
Compare 2 Sheets and Extract Unique Info to a 3rd Sheet | Excel Discussion (Misc queries) | |||
Is this simple I'm trying to compare values from 4 excel tables | Excel Worksheet Functions |