Exercises / Modern Excel: dynamic arrays · 2 of 12
A list of customers without repeats
UNIQUE(range) returns each distinct value once, in the order it first appears. The list spills down and updates when the data changes.
Your taskIn E2, use UNIQUE to list every customer in B2:B13 once.
Pro
Unlock this exercise and every module after the basics.
Pro opens every exercise in every module, your review schedule, and the final test for the course certificate.
| Row | A | B | C | D | E |
|---|---|---|---|---|---|
| 1 | Order | Customer | Amount | Customers | |
| 2 | #4001 | Brightlabs | $1,200.00 | ||
| 3 | #4002 | Nordicsoft | $860.00 | ||
| 4 | #4003 | Greenfield | $430.00 | ||
| 5 | #4004 | Brightlabs | $975.00 | ||
| 6 | #4005 | Kola Studio | $1,510.00 | ||
| 7 | #4006 | Nordicsoft | $640.00 | ||
| 8 | #4007 | Acme | $2,200.00 | ||
| 9 | #4008 | Brightlabs | $390.00 | ||
| 10 | #4009 | Greenfield | $1,105.00 | ||
| 11 | #4010 | Acme | $780.00 | ||
| 12 | #4011 | Romano Design | $1,320.00 | ||
| 13 | #4012 | Kola Studio | $455.00 |