Excel formula: Unique values case-sensitive
Unique values case-sensitive
Excel formula: Filter and sort without errors
Filter and sort without errors
Excel formula: Sum if case-sensitive
Sum if case-sensitive
Excel formula: Average if with filter
Average if with filter
Excel formula: Split text string to character array
Split text string to character array
Excel formula: Count numbers in text string
Count numbers in text string
Excel formula: Sum every nth row
Sum every nth row
Excel formula: Sum by quarter
Sum by quarter
Excel formula: Sum entire row
Sum entire row
Excel formula: Unique values from multiple ranges
Unique values from multiple ranges
Excel formula: MAP with AND and OR logic
MAP with AND and OR logic
Excel formula: Lookup number plus or minus N
Lookup number plus or minus N
Excel formula: Difference is within specific percentage
Difference is within specific percentage
Excel formula: Lookup first negative value
Lookup first negative value
Excel formula: Text is greater than number
Text is greater than number
Excel formula: Happy birthday message
Happy birthday message
Excel formula: Count birthdays by year
Count birthdays by year
Excel formula: Filter on dates expiring soon
Filter on dates expiring soon
Excel formula: 10 most common text values
10 most common text values
Excel formula: Future time intervals
Future time intervals
Excel formula: INDEX and MATCH advanced example
INDEX and MATCH advanced example
Excel formula: Sum time
Sum time
Excel formula: Sum numbers with text
Sum numbers with text
Excel formula: Count numbers with leading zeros
Count numbers with leading zeros
Excel formula: Rank and score with INDEX and MATCH
Rank and score with INDEX and MATCH
Excel formula: Count unique dates ignore time
Count unique dates ignore time
Excel formula: Count columns that contain specific values
Count columns that contain specific values
Excel formula: Combine ranges with CHOOSE
Combine ranges with CHOOSE
Excel formula: Dynamic summary count
Dynamic summary count
Excel formula: FILTER to show duplicate values
FILTER to show duplicate values
Excel formula: Remove time from timestamp
Remove time from timestamp
Excel formula: XLOOKUP return blank if blank
XLOOKUP return blank if blank
Excel formula: Random numbers without duplicates
Random numbers without duplicates
Excel formula: Get previous Sunday
Get previous Sunday
Excel formula: If date is between two dates
If date is between two dates
Excel formula: Calculate percentage of number
Calculate percentage of number
Excel formula: Dynamic calendar formula
Dynamic calendar formula
Excel formula: Get current stock price
Get current stock price
Excel formula: VLOOKUP with multiple criteria advanced
VLOOKUP with multiple criteria advanced
Excel formula: VLOOKUP case-sensitive
VLOOKUP case-sensitive
Excel formula: Currency exchange rate example
Currency exchange rate example
Excel formula: Get stock price last n months
Get stock price last n months
Excel formula: Get stock price last n days
Get stock price last n days
Excel formula: Get stock price on specific date
Get stock price on specific date
Excel formula: Get stock price (latest close)
Get stock price (latest close)
Showing 1 - 45 of 45 new formulas. More formulas here.