Formula hub · Updated May 13, 2026

Dynamic Arrays

Filter, sort, stack, and transform ranges with modern spreadsheet formulas.

Guides in this category

FILTER Formula Examples

Use FILTER to return only the rows or columns that match your conditions.

FILTER with Multiple Conditions

Use FILTER with two or more conditions in Excel or Google Sheets.

FILTER No Matches Found

Fix FILTER formulas that return no matches or show an error when nothing meets the condition.

ARRAYFORMULA for an Entire Column

Use ARRAYFORMULA in Google Sheets to fill a formula down a whole column automatically.

ARRAYFORMULA Not Working in Google Sheets

Fix ARRAYFORMULA issues caused by incompatible functions, missing blank checks, or mismatched ranges.

Sort Filtered Results in Excel or Google Sheets

Combine SORT and FILTER to return matching rows in a useful order.

Remove Blank Rows with a Formula

Use FILTER to return only nonblank rows from a spreadsheet range.

UNIQUE and SORT Together

Use UNIQUE and SORT to create a clean alphabetical list from repeated values.

Remove Duplicates with a Formula

Remove duplicate rows or values dynamically with UNIQUE in Excel or Google Sheets.

Transpose Rows and Columns

Flip rows into columns or columns into rows with the TRANSPOSE formula.

How to choose a formula

Start from the spreadsheet task, then choose the simplest formula that gives a maintainable answer. A report that someone else must update next month often needs clarity more than cleverness.