Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Comparing two spreadsheets
*Hi I have a problem comparing two spreadsheets of data/names. The problem: I have two lists with account names and numbers in coulumns A and B on sheet 1 and 2 Sheet 1 and 2 differ from each other in contents as well as number of accounts. Is it possible to compare the two sheets and show duplicate entries in a 3rd sheet??? (blanck sheet). In addition the two lists have a huge amount of data which make comparing in the same sheet difficult....... Have tried various formulas but have not yet succeded :( Hope that some of you can help :)* -- Morten ------------------------------------------------------------------------ Morten's Profile: http://www.excelforum.com/member.php...o&userid=28246 View this thread: http://www.excelforum.com/showthread...hreadid=478018 |
#2
|
|||
|
|||
Comparing two spreadsheets
Copy first columns A1 to B3147 (or whatever amount of lines there is) from Sheet 1 and paste them into Sheet 3!A1. The data will then lie in the same block as in Sheet 1. Then copy A1 to B8116 ( or whatever amount of lines there is in this sheet) from Sheet 2 and paste them into Sheet 3 below the first ones. In this example they will lie in the block from A3148 to B11263. In C1 write =IF(A1=A2;A1;""). Perhaps you must use comma instead of semicolon Copy C1 all the way down and include also column D Sort column A and B by A and you will see all the A duplicates in column C Sort column A and B by B and you will see all the B duplicates in column D Niels -- nsv ------------------------------------------------------------------------ nsv's Profile: http://www.excelforum.com/member.php...o&userid=26500 View this thread: http://www.excelforum.com/showthread...hreadid=478018 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comparing data from different spreadsheets???? | Excel Discussion (Misc queries) | |||
comparing excel spreadsheets from command line | Excel Discussion (Misc queries) | |||
Comparing data and updating spreadsheets | Excel Discussion (Misc queries) | |||
comparing 2 spreadsheets | Excel Discussion (Misc queries) | |||
Comparing Spreadsheets | Excel Worksheet Functions |