Excel Forum
Similar Content
Excel Formulas Won't Update
Tutorial: How to get your Excel formulas to update when you edit a worksheet. By default, each time...
Excel Formula to Get Domain Name from a URL
Tutorial: Two formulas that you can use to extract the domain name from a URL or to extract the sub-...
Excel Formula Formatting Trick to Make Life Easier
Tutorial: This Excel Quickie WILL make your life much easier with long formulas, even if you are al...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course




Excel Formula Efficiency 7: Helper Column Speeds Calculation


Count Unique Records with Formulas / Formula. See how to use a Helper Column to speed up calculations. See the COUNTIF and IF functions in an extra column to help speed up the calculation for Counting Unique Records. Also see a SUMPRODUCT and COUNTIF formula to count unique records.

Count Unique Records with Formulas / Formula

Learn how to speed up slow calculating spreadsheets with formulas that calculate faster. See many methods to speed up your spreadsheet decrease the amount of time it takes for the formulas to calculate. The tricks you see are from a White Paper called Improving Performance in Excel 2007. In this video series you will see tricks for both Excel 2003 and Excel 2007. Many of the large formulas in this series involve multi-conditional multiple criteria calculations that slow down the spreadsheet (worksheet, workbook).





Got a Question? Ask it Here in the Forum.