Summing Across Multiple Sheets
You might have come across an instance where you want to use a function against multiple sheets in a workbook. Excel provides an easy way to calculate aggregate functions across a range of sheets. In the examples below, you will see how this can be performed against any range of sheets and sheet names (or even [...]
Find the 2nd Largest Value in a Range
Excel provides an easy way to list the k-th (first, second, third, etc.) largest number in a range. We’ll also take a look at the opposite situation where you want to find the 2nd smallest value in a range, for example. Large & Small Formulas So let’s go ahead and take a look at the [...]
Quick Way to Check for Duplicates in a Column
I have been using this quick trick lately to check for duplicates in a column of values. Let’s say you have a list of a large group of numbers (characters work as well) and want to see if you have more than one instance of any of the numbers. To check for that, one simple [...]
Substitute Formula
The substitute formula is an relatively simple formula that can come in handy in many situations. I like to use this formula the most when a longer text field needs just a portion of it changed, without having to retype the entire cell value. Let’s go ahead and take a look at the substitute formula: [...]
Calculate a Loan Payment in Excel
Whether you are trying to buy a new house, looking at buying a new car or applying for MORE student loans, you have no doubt wondered what your monthly payment would be. Excel provides an easy to use formula in which you can enter the loan information, and it will calculate the monthly payment for you. [...]
