Array Formulas
Master Excel dynamic array formulas including FILTER, SORT, UNIQUE, SEQUENCE, and more. Create powerful spill formulas for modern Excel.
Functions in this Category
Common Use Cases
Dynamic filtering
Generate formula for this →Sorting data dynamically
Generate formula for this →Removing duplicates
Generate formula for this →Creating sequences
Generate formula for this →Multi-cell array operations
Generate formula for this →Detailed Function Guides
FILTER
Learn the FILTER function for dynamic array filtering in Excel 365. Create auto-updating filtered lists without helper columns....
Example:
=FILTER(A2:C100, B2:B100>1000)Filter rows where column B > 1000
SORT
Master the SORT function for dynamic array sorting in Excel 365. Sort data automatically without manual sort operations....
Example:
=SORT(A2:C100)Sort by first column ascending
UNIQUE
Learn UNIQUE to extract distinct values from a range. Create dynamic lists without duplicates that update automatically....
Example:
=UNIQUE(A2:A100)Get unique values from column A
Related Formula Categories
Need a Custom Array Formula?
Describe your calculation in plain English and our AI will generate the perfect formula for you.
Try Formula Generator Free