Excel LEFT, MID, and RIGHT: Extract Text Formulas
Extract SKU parts with TEXTSPLIT or LEFT/MID/RIGHT and FIND on older Excel.
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 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 to Join Cells with a Delimiter
Join Excel cells with TEXTJOIN, including skip-blanks and an ampersand fallback for Excel 2016.
Read articleExcel Formula to Remove Duplicates and Keep Unique Rows
Build a unique Excel list with UNIQUE/FILTER, or a COUNTIF helper column for Excel 2016.
Read articleExcel Formula to Calculate Working Days Between Dates
NETWORKDAYS and WORKDAY formulas for business-day counts, custom weekends, and holidays.
Read articleExcel Formula for Percentage of Total
Percentage-of-total and running-share formulas for Excel, with locked ranges for fill-down.
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: Sum Values Between Two Dates
Copy-ready SUMIFS formula to sum Excel values between two dates, plus variations for named cells and the current month.
Read article