| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compare entries in 2 worksheets and list what does not match
Good Day All;
I have 2 Excell works sheets with approx 14000 rows each. What I would like to do is compare both lists and get a 3rd list that shows what entries do not match. Is there a simple way to do ythis in Excel Thanks All Chomp |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Compare entries in 2 worksheets and list what does not match
Assuming A1 should equal A1 in the other sheet...
=IF(Sheet1!A1=Sheet2!A1,"",Sheet!A1&" does not match "&Sheet2!A1) Auto-Filter for non-blanks. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "The Chomp" wrote: Good Day All; I have 2 Excell works sheets with approx 14000 rows each. What I would like to do is compare both lists and get a 3rd list that shows what entries do not match. Is there a simple way to do ythis in Excel Thanks All Chomp |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Compare entries in 2 worksheets and list what does not match
Thank you very much Luke
"Luke M" wrote: Assuming A1 should equal A1 in the other sheet... =IF(Sheet1!A1=Sheet2!A1,"",Sheet!A1&" does not match "&Sheet2!A1) Auto-Filter for non-blanks. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "The Chomp" wrote: Good Day All; I have 2 Excell works sheets with approx 14000 rows each. What I would like to do is compare both lists and get a 3rd list that shows what entries do not match. Is there a simple way to do ythis in Excel Thanks All Chomp |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compare two worksheets and identify common entries | Excel Discussion (Misc queries) | |||
| Open two worksheets, then match and compare cells | Excel Programming | |||
| Compare worksheets and populate based on match | Excel Programming | |||
| How do I compare data from 2 worksheets to find duplicate entries | Excel Discussion (Misc queries) | |||
| Can I compare 2 lists to combine duplicate entries in new list? | Excel Worksheet Functions | |||
Linear Mode
