Flag duplicate DBS Bank transactions by customer and date together
Column A holds customer IDs, column B transaction dates. A duplicate transaction means the *same* customer ID *and* the *same* date both occur on another row — matching just one of the two isn't enough. Write formulas in C1:C5, one per row, that return TRUE for rows that are part of such a duplicate pair.
Starting grid
| A | B | C | |
|---|---|---|---|
| 1 | C001 | 2026-01-05 | |
| 2 | C002 | 2026-01-06 | |
| 3 | C001 | 2026-01-05 | |
| 4 | C003 | 2026-01-07 | |
| 5 | C002 | 2026-01-08 |
Basic
The expected output and walkthrough for this question unlock with a Basic plan.
Basic
The reference formulas and walkthrough for this question unlock with a Basic plan.
Basic
This is a Basic question
Premium practice questions unlock with a Basic plan. The full solution, expected output, and grading are available to Basic members.
RM 25/mo · cancel anytime