Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Comparing two data sets
I am trying to compare two data sets, but each data set may have different
records I will provide examples: Data Set 1 Data Set 2 Fac Item Amount Fac Item Amount 240 A123 100.00 240 A123 95.00 240 A124 50.00 240 A125 7.00 240 A125 8.00 240 A128 10.00 241 A123 45.00 241 A001 8.00 241 A155 10.00 241 A155 6.00 The results I would like to see: Data Set 1 Data Set 2 Fac Item Amount Fac Item Amount Var 240 A123 100.00 240 A123 95.00 5.00 240 A124 50.00 50.00 240 A125 7.00 240 A125 8.00 -1.00 240 A128 10.00 -10.00 241 A001 8.00 -8.00 241 A123 45.00 45.00 241 A155 10.00 241 A155 6.00 4.00 As you can see when I have my data sets at first the records are not lined up because the data records could be different in each data set. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Comparing two data sets
Visit Chip at www.cpearson.com where he has lots on finding duplicates
best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "PR1" wrote in message ... I am trying to compare two data sets, but each data set may have different records I will provide examples: Data Set 1 Data Set 2 Fac Item Amount Fac Item Amount 240 A123 100.00 240 A123 95.00 240 A124 50.00 240 A125 7.00 240 A125 8.00 240 A128 10.00 241 A123 45.00 241 A001 8.00 241 A155 10.00 241 A155 6.00 The results I would like to see: Data Set 1 Data Set 2 Fac Item Amount Fac Item Amount Var 240 A123 100.00 240 A123 95.00 5.00 240 A124 50.00 50.00 240 A125 7.00 240 A125 8.00 -1.00 240 A128 10.00 -10.00 241 A001 8.00 -8.00 241 A123 45.00 45.00 241 A155 10.00 241 A155 6.00 4.00 As you can see when I have my data sets at first the records are not lined up because the data records could be different in each data set. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comparing sets of data, where criteria met, sum certain columns. | Excel Worksheet Functions | |||
Comparing two sets of columns | Excel Discussion (Misc queries) | |||
Comparing two different sets of data with common element | Excel Worksheet Functions | |||
Comparing two sets data for different month | Excel Discussion (Misc queries) | |||
help comparing two sets od data to find the odd data | Excel Worksheet Functions |