Exercises / Modern Excel: dynamic arrays · 3 of 12
How many different customers?
Functions can take a spilled list as input. COUNTA(UNIQUE(range)) counts the distinct values, a question that used to need a PivotTable.
Your taskIn F2, use COUNTA and UNIQUE to count how many different customers appear in B2:B13.
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 | F |
|---|---|---|---|---|---|---|
| 1 | Order | Customer | Amount | Measure | Value | |
| 2 | #4001 | Brightlabs | $1,200.00 | Customers | ||
| 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 |