Excel FILTER Formula for a Unique, Conditioned List
FILTER+UNIQUE lists of Excel values that match AND/OR criteria, with SORT and multi-column spills.
Read articleFormula guides
Copy-ready formulas for common Excel, Sheets, and WPS tasks.
Excel RANK Formula That Handles Ties
RANK.EQ, RANK.AVG, and unique-rank formulas for Excel leaderboards with ties.
Read articleExcel Formula for Currency Conversion
Multiply by a locked FX cell, look up rates with VLOOKUP, and ROUND converted amounts.
Read articleExcel Formula to Highlight or List Duplicate Values
COUNTIF formulas that label, highlight, or list duplicate Excel values.
Read articleExcel SUMIFS as a Live Alternative to a Pivot Table
Build a live Excel crosstab with SUMIFS instead of a pivot table, including date filters.
Read articleWPS Spreadsheet SUMIF / SUMIFS with Multiple Criteria
WPS-safe SUMIFS and SUMPRODUCT formulas for multiple criteria without Excel 365 functions.
Read articleGoogle Sheets ARRAYFORMULA with IF
ARRAYFORMULA+IF patterns that auto-fill Google Sheets columns as new rows appear.
Read articleExcel IFERROR VLOOKUP: Replace #N/A with a Message
Wrap VLOOKUP in IFERROR, chain a second table, or use XLOOKUP’s if_not_found argument.
Read articleExcel LEFT, MID, and RIGHT: Extract Text Formulas
Extract SKU parts with TEXTSPLIT or LEFT/MID/RIGHT and FIND on older Excel.
Read articleExcel COUNTIFS Between Two Numbers
COUNTIFS formulas that count values between two numbers, with category and AVERAGEIFS variants.
Read articleExcel Formula for Year-over-Year Growth
Year-over-year growth, zero-safe rates, last-year SUMIFS, and a five-year CAGR formula.
Read articleExcel Formula to Flag Rows That Meet a Condition
Build an Overdue/OK flag column with IF and AND, plus 1/0 flags you can SUM.
Read articleExcel Approximate Match VLOOKUP for Tax Brackets
Approximate VLOOKUP and XLOOKUP for tax brackets and other sorted threshold tables.
Read articleExcel Formula to Round to the Nearest 0.05 or 5
Round Excel numbers to 0.05 or 5 with MROUND, CEILING, FLOOR, or a ROUND workaround.
Read articleExcel Formula to Extract Domain from an Email Address
Pull the domain from an email in Excel with TEXTAFTER or MID/FIND for older versions.
Read articleExcel Formula to Calculate Age from a Birthday
DATEDIF age formulas for whole years or years-and-months, plus an INT approximation.
Read articleExcel Formula to Get the Last Non-Empty Cell in a Column
LOOKUP and TAKE formulas that always return the last non-empty Excel cell in a growing column.
Read articleExcel Formula for Percentage of Total
Percentage-of-total and running-share formulas for Excel, with locked ranges for fill-down.
Read article