Formula Related Functions
Summarize weather data by day and month GROUPBY HSTACK MAP DROP CHOOSECOLS LAMBDA LET XLOOKUP EOMONTH INT TEXT
Fuzzy match noisy data GROUPBY XLOOKUP XMATCH FILTER UNIQUE VLOOKUP MATCH ISNA
Convert UTC timestamp to Excel datetime SUBSTITUTE TEXTSPLIT TIME SUM
Number to words LET LAMBDA MOD MAP INT INDEX CHOOSE ISOMITTED
Encode Unicode sequence into text UNICHAR TEXTSPLIT TEXTJOIN HEX2DEC
Get Unicode Sequence from text UNICODE REGEXEXTRACT BASE TEXTJOIN
GROUPBY with monthly totals GROUPBY HSTACK CHOOSECOLS TEXT MONTH SUMPRODUCT EOMONTH
List all dates in a month SEQUENCE EOMONTH DAY LET
GROUPBY with survey results GROUPBY PERCENTOF HSTACK SORTBY XMATCH CHOOSECOLS
Look up and return to single cell FILTER TEXTJOIN GROUPBY LAMBDA UNIQUE ARRAYTOTEXT
Sum if with multiple ranges SUMIFS LET VSTACK GROUPBY CHOOSECOLS
Step-based lookup example INDEX MATCH
Simple investing worksheet FV
XLOOKUP with regex match XLOOKUP
Extract date from text string MID SEARCH REGEXEXTRACT
Validate strong password REGEXTEST COUNT FIND LEN UPPER ISERROR
Income tax bracket calculation IF LET VSTACK DROP XLOOKUP XMATCH FILTER OFFSET CHOOSECOLS
Tiered discounts based on quantity MAP VSTACK DROP IF MIN MAX
Filter and exclude columns FILTER SORT CHOOSECOLS TAKE
Repeat sequence of numbers SEQUENCE MOD
Repeat range of values SEQUENCE MOD CHOOSEROWS CHOOSECOLS
Generate quarter dates EDATE SEQUENCE EOMONTH
Add workdays to date custom workweek WORKDAY.INTL WORKDAY
Extract numbers from text TEXTSPLIT TOROW DROP
Time in hundredths of a second TIME SECOND TIMEVALUE MOD
Sequence of leap years SEQUENCE LET FILTER MOD BYROW AND OR
Count errors in all sheets SUMPRODUCT ISERROR INDIRECT HYPERLINK ISREF
Extract common values from text strings FILTER XMATCH ISNUMBER LET SORT
TEXTSPLIT get numeric values TEXTSPLIT VALUE IFERROR LET
Cell contains specific words TEXTSPLIT XMATCH COUNT COUNTA LET
Split full name into parts LET TEXTSPLIT INDEX COUNTA DROP TEXTJOIN HSTACK
Sort by substring SORTBY TEXTBEFORE TEXTAFTER
Mortgage payment schedule LET SEQUENCE SCAN FILTER PMT IPMT PPMT HSTACK VSTACK
List nth weekdays of the month LET SEQUENCE FILTER EOMONTH TEXT EDATE
Previous working day WORKDAY WORKDAY.INTL
Biweekly pay schedule SEQUENCE WORKDAY
Semimonthly pay schedule FILTER SEQUENCE LET DAY EOMONTH WORKDAY
List workdays between dates LET SEQUENCE FILTER WEEKDAY WORKDAY.INTL
Combine data in multiple worksheets VSTACK FILTER LET CHOOSECOLS
Remove blank rows FILTER BYROW
Row is blank SUMPRODUCT BYROW LAMBDA
Sequence of workdays SEQUENCE WORKDAY.INTL ROW
Dynamic range between two matches XLOOKUP INDEX MATCH COUNT
INDEX and MATCH two-column lookup INDEX XMATCH XLOOKUP CHOOSECOLS
Get first numeric value in a range XLOOKUP ISNUMBER INDEX MATCH
Calculate sales commission with if IF IFS
Sum numbers in single cell TEXTSPLIT SUM FILTERXML SUBSTITUTE
Quantity based discount XLOOKUP INDEX MATCH IFNA
XMATCH with multiple criteria XMATCH XLOOKUP INDEX MATCH
XLOOKUP binary search XLOOKUP INDEX XMATCH
INDEX and MATCH with variable columns INDEX XMATCH XLOOKUP CHOOSECOLS