List Countries with Orders
I need a unique list of 'Shipping Country' from last month's sales report to plan our ad spend.
=UNIQUE(C2:C8) How it works: The UNIQUE function extracts all distinct values from a specified range, automatically spilling them into adjacent cells. This is perfect for getting a clean list of countries without duplicates, which is essential for targeted ad spend planning and market analysis, ensuring you don't over-allocate resources to the same region multiple times.
Data Setup
| Order ID | Product | Shipping Country | Sales Amount |
|---|---|---|---|
| 1001 | Laptop | USA | 1200 |
| 1002 | Mouse | Canada | 25 |
| 1003 | Keyboard | USA | 75 |
| 1004 | Monitor | Mexico | 300 |
| 1005 | Webcam | Canada | 50 |
| 1006 | Headphones | USA | 150 |
| 1007 | Microphone | Mexico | 80 |
Step-by-Step Guide
Open your sales report in Excel.
Identify the column containing the 'Shipping Country' data (e.g., Column C).
Select an empty cell where you want the unique list of countries to appear.
Type the formula `=UNIQUE(`
Select the range of cells containing the 'Shipping Country' data, including all rows with data but excluding the header (e.g., `C2:C8`).
Close the parenthesis and press Enter: `=UNIQUE(C2:C8)`.