M
menken.john
I'm using an Excel 2010 workbook with two sheets in it. Sheet A and Sheet Bhave numeric data with subtotal rows under each group of data. Each subtotal row is totaled in the last column.
Sheet A and Sheet B are set up the same in that they have similar data, same number of columns, same need for subtotals, etc. Here is the only difference, Sheet B has a few more rows sprinkled throughout than does Sheet A.
What I need to do is create one equation in Sheet C that calculates the Delta between the subtotal totals of each sheet. This is easy if each row lined up but unfortunately that is not the case. Is my "one equation" hope possible? Thanks very much for your help.
Sheet A and Sheet B are set up the same in that they have similar data, same number of columns, same need for subtotals, etc. Here is the only difference, Sheet B has a few more rows sprinkled throughout than does Sheet A.
What I need to do is create one equation in Sheet C that calculates the Delta between the subtotal totals of each sheet. This is easy if each row lined up but unfortunately that is not the case. Is my "one equation" hope possible? Thanks very much for your help.