Excel dynamic arrays practice: FILTER, SORT and UNIQUE
Lesson 10 · Pro
✓
Lesson 10 done.
You can make one formula fill a whole range: a list without duplicates, sorted, filtered on one condition or several, with a fallback for when nothing matches. You know what #SPILL! and #CALC! are asking for, and how to point a second formula at a whole spilled list with #. That's a report that rebuilds itself when the data changes, with nothing to copy down.
More Excel practice
Excel practice onlineExcel skills testExcel formula playgroundExcel practice for beginnersExcel IF function practiceVLOOKUP practice exercisesXLOOKUP practice exercisesSUMIFS and COUNTIFS practiceINDEX MATCH practice exercisesExcel date functions practiceExcel keyboard shortcuts practicePivot table practice exercisesExcel functions with live examplesExcel formula errors, fixed liveExcel test for job interviews, with answersSQL practice onlineLearn to read financial statements