Calculate cap percentage at specific amount in Excel
This tutorial shows how to calculate a percentage based value capped at a specific amount … Read More
Calculate max or min change in a set of data in Excel
To calculate the max or min change in a set of data as shown, without … Read More
Split numbers from units of measure in Excel
To split a number from a unit value, you need to determine the position of … Read More
How to extract word containing specific text in Excel
To extract a word that contains specific text,you can use a formula based on several … Read More
Two ways to sum time over 30 minutes in Excel
To sum the total amount of time over 30 minutes, given a set of times … Read More
Calculate total hours that fall between two times in Excel
Case study
You have a start time and an end time, and you want to … Read More
Calculate date overlap in days in Excel
If you need to calculate the number of days that overlap in two date ranges, … Read More
Force negative numbers to zero in Excel
This tutorial shows how to Force negative numbers to zero in Excel using the example … Read More
Position of max value in list in Excel
This tutorial shows how to calculate Position of max value in list in Excel using
… Read More Max if criteria match in Excel
This tutorial shows how to calculate Max if criteria match in Excel using the example … Read More
Get location of value in 2D array in Excel
This tutorial shows how to Get location of value in 2D array in Excel using … Read More
Get information corresponding to max value in Excel
This tutorial shows how to Get information corresponding to max value in Excel using the … Read More
Find longest string with criteria in Excel
This tutorial shows how to Find longest string with criteria in Excel using the example … Read More
Find longest string in column in Excel
This tutorial shows how to Find longest string in column in Excel using the example … Read More
Extract data with helper column in Excel
This tutorial shows how to Extract data with helper column in Excel using the example … Read More
Calculate shipping cost with VLOOKUP in Excel
This tutorial shows how to Calculate shipping cost with VLOOKUP in Excel using the example … Read More
nth largest value with duplicates in Excel
This tutorial shows how to calculate nth largest value with duplicates in Excel using the … Read More
nth largest value in Excel
This tutorial shows how to calculate nth largest value in Excel using the example below;… Read More
Maximum value if in Excel
This tutorial shows how to calculate Maximum value if in Excel using the example below;… Read More
Maximum value in Excel
This tutorial shows how to calculate Maximum value in Excel using the example below;