Skip to main content
SheetTutor.
SheetTutorLearn Excel by playBack to task

Reconcile grouped totals from two exports

Your goal: Keep the union of both ID lists, combine signed repeated rows on each side, then report both totals and their difference.

Full task requirements

Enter one formula in G5. Return each nonblank ID occurring in A2:A9 or D2:D11 once, uppercased, in first-seen order across A then D. Report its signed numeric total from B, total from E and A minus B. Match printable ASCII IDs literally ignoring case; spaces and leading zeroes remain significant. Repeated IDs are aggregated, missing-side totals are numeric zero, and zero-net keys remain. If both lists are empty, return No keys.

Aggregate repeats and retain keys found on either sideBuild the complete first-seen key union0 cells selected
Tap identifier or key cells for this decision Drag from selected cells to deselect.
#
1
2
3
4
5
6
7
8
9
10
11
Step 1 of 6

Build the complete first-seen key union

Select the matching value or key cells in the worksheet, then check your choice.

Rules for this step

Read source A before source B. Select each nonblank key’s first occurrence across that combined order, ignoring only letter case. Keep keys whose signed total later cancels to zero.

Your selected source cells will appear here.

Uppercase keys in source order
Choose the first source occurrences
0 cells selected