Marc L
Excel Ninja
Did you have a solution for the problem?
Maybe but not with formulas !
Maybe from raw data workbook, faster with one to one easy reconcilation rather than 'complex' reconciliation
and with an elaboration at the level of what any Excel forum expects for …