TABLES COURSE · Step 8 of 20

Report distinct and exactly-once combinations

Lesson instructions

Use the complete current exercise check before saving. Navigation does not record a pass.

Before this step: Distinguish selecting a representative from changing source transactions.

A two-column UNIQUE report compares complete Region/Product pairs. Default uniqueness keeps the first spelling of every pair; exactly once excludes every repeated pair. Both reports spill outside the Table and preserve all source records.

Open the unique-combinations project and enter both source-dependent report formulas at A2 and D2.
Compare distinct and exactly-once results; include the staged next Table record and inspect their changed membership.
Check every current cell, both exact spill shapes and eight changed-source calculations before saving.

Original source

Teaching · read-only · Report!A1

Step 1 / 5Choose the identity of a combination

Inspect

Region and Product together identify a pair. Repeated pairs remain separate source transactions with their own record, month, status and amount. Teaching is read-only; switch to Your turn to edit.

Source!C2 · (blank)
No formula applied

Loading your interactive spreadsheet…

No supported complete Orders Table is available. Use Redo or reset the project to restore its structure.

A complete extra record is staged directly below the initial Table. Include it, then observe both dependent spill reports. Resize and input edits are actual worksheet history actions.

Report anchor Formula

Inspect both reference formulas

=UNIQUE(Orders[[Region]:[Product]])

=IFERROR(UNIQUE(Orders[[Region]:[Product]],FALSE,TRUE),"None")

FALSE compares rows. TRUE in the third argument selects only combinations whose source count is one. IFERROR gives the scalar text None when no combination occurs exactly once; it does not create a two-column result in that case. A None result cannot hide other workbook errors from the complete check.

Worksheet Cell Type Value

Restore the complete typed source and native Table before interpreting these reports.

Row	Distinct Region	Distinct Product	Once Region	Once Product
2

Both anchors live outside Orders. Occupying a spill destination blocks calculation. Clear the blocking value or undo it in the worksheet before checking again. Copies contain the actual current Table and sheets. Desktop Excel editing and spill resizing need separate verification.