Excel shortcuts

8 Expert Tips for Using UNIQUE and Other Functions in Excel

1. UNIQUE + FILTER
Use =UNIQUE(FILTER(B2:B11, C2:C11="Tech")) to filter and extract unique product names from the "Tech" category. This helps you focus on specific subsets of your data.

2. UNIQUE + SORT
Apply =SORT(UNIQUE(D2:D11)) to list unique prices in ascending order, making it easier to analyze price points in your dataset.

3. UNIQUE + COUNTIF
With =COUNTIF(B2:B11, UNIQUE(B2:B11)), you can count how often each unique product name appears, helping you identify popular or underperforming items.

4. UNIQUE + SUMIF
Use =SUMIF(B2:B11, UNIQUE(B2:B11), E2:E11) to calculate total sales for each unique product. This shows which products generate the most revenue.

5. UNIQUE + AVERAGEIF
The formula =AVERAGEIF(B2:B11, UNIQUE(B2:B11), D2:D11) gives you the average price for each unique product, helping to assess competitive pricing.

6. UNIQUE + VLOOKUP
Use =VLOOKUP(UNIQUE(B2:B11), B2:D11, 3, FALSE) to find the price of the first unique product, making data retrieval quick and simple.

7. UNIQUE + IF
With =UNIQUE(IF(D2:D11>500, B2:B11, "")), you can list unique products priced over 500, which helps to identify premium offerings.

8. UNIQUE + XLOOKUP
Use =XLOOKUP(INDEX(UNIQUE(B2:B11), 1), B2:B11, C2:C11) to find the category of the first unique product, making data analysis more efficient.