FILTER with OR

Advanced← PreviousSkip →
Exercise 10 of 11 Premium

List every product that is in Lighting or is out of stock.

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. 1.Filter a list
  2. 2.Unique values
  3. 3.Out of stockPremium
  4. 4.FILTER by a numberPremium
  5. 5.Count unique valuesPremium
  6. 6.Sort by pricePremium
  7. 7.Top 3 with TAKEPremium
  8. 8.Stock value with FILTERPremium
  9. 9.FILTER with ANDPremium
  10. 10.FILTER with ORPremium
  11. 11.Name parts with LETPremium
See the whole topic →