easyCarousell · aggregation
Flag Carousell listings that were posted more than once
Column A holds listing titles, some posted more than once by mistake. Write formulas in B1:B5, one per row, that return TRUE if that row's title appears anywhere else in the column, and FALSE otherwise.
Starting grid
A1
| A | B | |
|---|---|---|
| 1 | iPhone 12 | |
| 2 | Study Table | |
| 3 | iPhone 12 | |
| 4 | Gaming Chair | |
| 5 | Study Table |
Show expected output▾
Stuck? Ask the coach for a nudge that won't give the answer away, or reveal the reference solution and a short walkthrough of why it works.
B1
| A | B | |
|---|---|---|
| 1 | iPhone 12 | |
| 2 | Study Table | |
| 3 | iPhone 12 | |
| 4 | Gaming Chair | |
| 5 | Study Table |