Excel 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 articleExcel Formula to Highlight or List Duplicate Values
COUNTIF formulas that label, highlight, or list duplicate Excel values.
Read articleExcel Formula for Currency Conversion
Multiply by a locked FX cell, look up rates with VLOOKUP, and ROUND converted amounts.
Read articleExcel RANK Formula That Handles Ties
RANK.EQ, RANK.AVG, and unique-rank formulas for Excel leaderboards with ties.
Read articleExcel 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 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 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 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 Approximate Match VLOOKUP for Tax Brackets
Approximate VLOOKUP and XLOOKUP for tax brackets and other sorted threshold tables.
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 article