Excel formula: Cell contains specific words
Cell contains specific words
Excel formula: Split full name into parts
Split full name into parts
Excel formula: Sort by substring
Sort by substring
Excel formula: Mortgage payment schedule
Mortgage payment schedule
Excel formula: List nth weekdays of the month
List nth weekdays of the month
Excel formula: Previous working day
Previous working day
Excel formula: Biweekly pay schedule
Biweekly pay schedule
Excel formula: Semimonthly pay schedule
Semimonthly pay schedule
Excel formula: List workdays between dates
List workdays between dates
Excel formula: Combine data in multiple worksheets
Combine data in multiple worksheets
Excel formula: Remove blank rows
Remove blank rows
Excel formula: Row is blank
Row is blank
Excel formula: Sequence of workdays
Sequence of workdays
Excel formula: Dynamic range between two matches
Dynamic range between two matches
Excel formula: INDEX and MATCH two-column lookup
INDEX and MATCH two-column lookup
Excel formula: Get first numeric value in a range
Get first numeric value in a range
Excel formula: Calculate sales commission with if
Calculate sales commission with if
Excel formula: Sum numbers in single cell
Sum numbers in single cell
Excel formula: Quantity based discount
Quantity based discount
Excel formula: XMATCH with multiple criteria
XMATCH with multiple criteria
Excel formula: XLOOKUP binary search
XLOOKUP binary search
Excel formula: INDEX and MATCH with variable columns
INDEX and MATCH with variable columns
Excel formula: XLOOKUP approximate match with multiple criteria
XLOOKUP approximate match with multiple criteria
Excel formula: XLOOKUP without #N/A error
XLOOKUP without #N/A error
Excel formula: Count cells that contain formulas
Count cells that contain formulas
Excel formula: Replace one delimiter with another
Replace one delimiter with another
Excel formula: Filter with multiple criteria
Filter with multiple criteria
Excel formula: Cell ends with
Cell ends with
Excel formula: Cell begins with
Cell begins with
Excel formula: Highlight specific day of week
Highlight specific day of week
Excel formula: Required recovery rate
Required recovery rate
Excel formula: Average salary by department
Average salary by department
Excel formula: Average by group
Average by group
Excel formula: Sum last n rows
Sum last n rows
Showing 1 - 34 of 34 new formulas. More formulas here.