Let’s say you have a list of invoices. But what you really want to know is which customers are on that list. You could sort the list by customer name, but here’s an easier solution.
In the example below, our original report is in columns A through D. In cell F2, enter the formula =UNIQUE(C2:C8). That tells Excel to look in cells C2 through C8 and give you each unique entry that appears in that range. You can see that the result is a list of four names.
Even though there are 4 names listed in column F. Only cell F2 contains a formula. the UNIQUE() function will “spill” the results into as many cells as needed.
| A | B | C | D | E | F | |
| 1 | Invoice/CM # | Date | Name | Amount | ||
| 2 | 10304 | 3/4/24 | Holland Properties, Inc. | 168.96 | Holland Properties, Inc. | |
| 3 | 10329 | 3/4/24 | Archer Scapes and Ponds | 59.98 | Archer Scapes and Ponds | |
| 4 | 10330 | 3/4/24 | Holland Properties, Inc. | 139.97 | Roberts Learning Centers | |
| 5 | 10331 | 3/4/24 | Roberts Learning Centers | 39.99 | Gordon Park & Recreation Center | |
| 6 | 10332 | 3/4/24 | Holland Properties, Inc. | 129.97 | ||
| 7 | 10333 | 3/4/24 | Gordon Park & Recreation Center | 39.99 | ||
| 8 | 10334 | 3/4/24 | Archer Scapes and Ponds | 59.98 | ||
| 9 | ||||||
| 10 | Total | 638.84 |
