Reconcile grouped totals from two exports
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.
The answer cells begin blank. Enter a reusable formula and check it against the published practice datasets. Hints and the solution are available when you choose them.
Practice stays on this device. No worksheet data is uploaded.
A checkpoint records a fresh check of every dataset. This attempt tracks built-in hints, solutions, steps and worked examples; it does not establish independent authorship.
Help recorded: none of these built-in aids opened.
Make the formula your own.
View 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.
No account. No upload. Just try it.