Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Comparing sets of data, where criteria met, sum certain columns.
Microsoft 2003 - I have to compare data extracted from one application to
data extracted from another application and resolve all discrpancies between the two files. Any ideas on how to do this? The file has 8 columns - 4 from one application and 4 from the other application (columns a1:d55 is company "XYZ", columns e1:h500 is company "ABC"). I need the formula to subtract the contents of column 'd' from column 'h' where contents of column 'a' are found in column 'e'. These are not always on the same row. Sometimes the match occurs on row one of column 'a' and row three of column 'e'. In addition it is also possible that no match is found at all. Any suggestions would be appreciated. Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
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 | |||
Comparing Data in 2 columns | Excel Worksheet Functions |