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