List Top Referrers
I need a unique list of Affiliate IDs that drove traffic yesterday.
=UNIQUE(B2:B10) How it works: The UNIQUE function scans the specified range (e.g., B2:B10) and extracts every distinct value it finds. This is perfect for an Affiliate Manager who needs to quickly identify all unique affiliates that generated activity without manual deduplication, providing a clean list for further analysis or reporting.
Data Setup
| Date | Affiliate ID | Clicks | Conversions |
|---|---|---|---|
| 2023-10-26 | AFF001 | 150 | 5 |
| 2023-10-26 | AFF002 | 200 | 8 |
| 2023-10-26 | AFF003 | 120 | 3 |
| 2023-10-26 | AFF001 | 100 | 4 |
| 2023-10-26 | AFF004 | 180 | 6 |
| 2023-10-26 | AFF002 | 90 | 2 |
| 2023-10-26 | AFF005 | 250 | 10 |
| 2023-10-26 | AFF003 | 70 | 1 |
| 2023-10-26 | AFF001 | 50 | 2 |
Step-by-Step Guide
Ensure your affiliate traffic data is organized, with 'Affiliate ID' in column B.
Select an empty cell where you want the unique list to appear (e.g., D2).
Enter the formula `=UNIQUE(B2:B10)` (adjust the range `B2:B10` to cover all your Affiliate IDs for yesterday's traffic).
Press Enter. Excel will automatically spill the unique list of Affiliate IDs into adjacent cells, starting from D2.