Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
COMPARE 2 SPREADSHEETS
Hello again,
This forum is so hopeful to me, it sure gave me a boost in my position at work. Thank you all. I have now an urgent request for help. I have 2 spreadsheets each 10 columns and 500 rows. Column "G" is identical all other columns have different information. I have to combine the two spreadsheets. Rather I have to insert column "D" from spreadsheet 1 to spreadsheet 2. Column "G" is indentical in both spreadsheets. If I can get an answer for this will help me a lot. I hope I made it clear. Thank You -- smile |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
COMPARE 2 SPREADSHEETS
One way:
If column G is truly IDENTICAL, just copy Column D on Sheet 1 and paste to Sheet2. If instead, the information in Column G on sheet 2 is the same as that in Column G in sheet1, but perhaps in a different order, put this in column K of sheet 2: K1: =INDEX(Sheet1!D:D, MATCH(G1,Sheet1!D:D,FALSE)) In article , israel wrote: Hello again, This forum is so hopeful to me, it sure gave me a boost in my position at work. Thank you all. I have now an urgent request for help. I have 2 spreadsheets each 10 columns and 500 rows. Column "G" is identical all other columns have different information. I have to combine the two spreadsheets. Rather I have to insert column "D" from spreadsheet 1 to spreadsheet 2. Column "G" is indentical in both spreadsheets. If I can get an answer for this will help me a lot. I hope I made it clear. Thank You |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
COMPARE 2 SPREADSHEETS
In Sheet2,
Assuming data starts in row2 down, and you want to extract it into col D In D2: =IF(ISNA(MATCH(G2,Sheet1!G:G,0)),"",INDEX(Sheet1!D :D,MATCH(G2,Sheet1!G:G,0))) Copy D2 down to extract data from Sheet1's col D* for the matched values in col G. *that's the col specified in this part: .. INDEX(Sheet1!D:D The above will do the job even if the order of the match values in col G in both Sheet1/2 are different -- Max Singapore http://savefile.com/projects/236895 Downloads:22,500 Files:370 Subscribers:66 xdemechanik --- "israel" wrote: I have now an urgent request for help. I have 2 spreadsheets each 10 columns and 500 rows. Column "G" is identical all other columns have different information. I have to combine the two spreadsheets. Rather I have to insert column "D" from spreadsheet 1 to spreadsheet 2. Column "G" is indentical in both spreadsheets. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
compare 2 spreadsheets | Excel Worksheet Functions | |||
Compare spreadsheets | Excel Worksheet Functions | |||
how can I compare two excel spreadsheets? | Excel Worksheet Functions | |||
Compare Two Spreadsheets | Excel Discussion (Misc queries) | |||
How can I compare to spreadsheets | Excel Worksheet Functions |