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.
