Count unique values
Exercise 5 of 11 Premium
How many different categories are there? Use one formula that still works when new categories are added.
Checking your plan…
inventory.xlsx
ABCDE
1SKUProductCategoryPriceStock
2
3
4
5
6
7
8
About dynamic arrays in Excel
Modern Excel formulas can return a whole list that spills into the cells below. Practice FILTER, UNIQUE and SORTBY on an inventory table, and combine them with SUM for one-cell answers.
Functions you can use here
FILTER(array, include, [if_empty])UNIQUE(array, [by_col], [exactly_once])SORTBY(array, by_array1, [sort_order1], …)LET(name1, value1, [name2, value2, …], calculation)
More dynamic arrays exercises
- 1.Filter a list
- 2.Unique values
- 3.Out of stockPremium
- 4.FILTER by a numberPremium
- 5.Count unique valuesPremium
- 6.Sort by pricePremium
- 7.Top 3 with TAKEPremium
- 8.Stock value with FILTERPremium
- 9.FILTER with ANDPremium
- 10.FILTER with ORPremium
- 11.Name parts with LETPremium