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).

Category:

Science & Technology

Tags:

• Excel
• See
• how
• to
• use
• Helper
• Column
• speed
• up
• calculations
• Count
• Unique
• Records
• Mike
• Gel
• Girvin
• Highline
• Community
• College

[Mascafequeleche]

Incredible. I viewed your series on Excel Formula Efficiency and I'm blown away. I totally forgot that Excel 2007 now allows for Sumif(s) whereas 2003 did not hence me using sumproduct. You proved that it's faster and I'm sure going to slowly change all my dashboards to sumifs to speed up calculation.

Thank you! This helped so much.

The Helper Cell is unbelivable. Going to see how I can use it. Love your vids!!

[ExcelIsFun]

I am glad that this helped. I was similarly happy when I read the white paper that promoted me to make the videos!