Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I use Excel to compare two list
I have a massive spreadsheat of MRP data for each partnumber in the system.
There are over 13,000 rows of data with fields going out to column BN. I need to compare a list of known good data to an updated list to see if any data has changed and if any new partnumbers were added. I have tried the 4 TOPS software I found on this site but I don't really trust it yet. It seems to be always running in the background even after I shut it off. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I use Excel to compare two list
Here's a small example I concocked:
In Sheet1 I entered into A1:C3 abc dfg uyt 123.00 fg tre 543.00 gh 432.00 In Sheet2 I entered into A1:C3 abc ldfg uyt 123.00 fg tre 543.00 gggh 432.00 In Sheet3 - Cell A1 I entered =EXACT(Sheet1!A1,Sheet2!A1) and then copied to all cells thru C3. Any Cell in sheet3 with TRUE means No Differences in Sheet1 and Sheet2 False indicates a Difference; Hope this helps, Jim "Data Miner" wrote: I have a massive spreadsheat of MRP data for each partnumber in the system. There are over 13,000 rows of data with fields going out to column BN. I need to compare a list of known good data to an updated list to see if any data has changed and if any new partnumbers were added. I have tried the 4 TOPS software I found on this site but I don't really trust it yet. It seems to be always running in the background even after I shut it off. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I use Excel to compare two list
This does help however I have found that some of my data is out of sequence
gives me in accurate "FALSE" responses. Several Part numbers were added to the middle of the new list and throws off the report. Once I added spaces to the old list to compensate, the formula works great. Finding and fixing the mismatches is time consuming. "Jim May" wrote: Here's a small example I concocked: In Sheet1 I entered into A1:C3 abc dfg uyt 123.00 fg tre 543.00 gh 432.00 In Sheet2 I entered into A1:C3 abc ldfg uyt 123.00 fg tre 543.00 gggh 432.00 In Sheet3 - Cell A1 I entered =EXACT(Sheet1!A1,Sheet2!A1) and then copied to all cells thru C3. Any Cell in sheet3 with TRUE means No Differences in Sheet1 and Sheet2 False indicates a Difference; Hope this helps, Jim "Data Miner" wrote: I have a massive spreadsheat of MRP data for each partnumber in the system. There are over 13,000 rows of data with fields going out to column BN. I need to compare a list of known good data to an updated list to see if any data has changed and if any new partnumbers were added. I have tried the 4 TOPS software I found on this site but I don't really trust it yet. It seems to be always running in the background even after I shut it off. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 List does not preserve border style for all rows | Excel Discussion (Misc queries) | |||
Is there an excel funtion that retreives the last cell of a list | Excel Worksheet Functions | |||
How do I create a List in Excel 2000 | Excel Worksheet Functions | |||
How do I Compare and Merge Workbooks in Excel? | Excel Discussion (Misc queries) | |||
Excel 2003: Match one list against another and highlight differenc | Excel Worksheet Functions |