Excel: UNIQUE, FILTER and SORT

Sign up free to unlock this topic

Kindergarten is free, and guests can try one sample topic in every other grade. A free parent or teacher account opens every topic from Kindergarten to Grade 12, college and university, and saves progress. No credit card.

Try the free sample: The ideal gas law · Have a class or homeroom code? Join here

Key idea: Excel: UNIQUE, FILTER and SORT

Dynamic array functions return a whole list that spills into the cells below. UNIQUE lists each value once, FILTER keeps the rows where a test is TRUE, and SORT puts a list in order. Wrap them in SUM or COUNTA to get one number.

Key words

(test1)*(test2)
Both tests: AND inside FILTER.
#SPILL!
The cells below aren't empty.

🔎 What to look for: Tests inside FILTER compare a whole column at once.

Zero2Hero — Zéro2Héros