Dec 8 2008

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 [...]

Nov 16 2008

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 [...]

Aug 28 2008

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 [...]

Aug 17 2008

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: [...]

Oct 1 2007

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.  [...]

Page 2 of 512345
  • Expert Excel Consultants for Business
  • Excel Consultants and Access Programmers

Sign Up for Excel Hints

Free updates with Excel Hints, Tips & Tricks

Categories