06
Jan 2014

- BY Kevin Lehrbass
- POSTED IN Solutions
- WITH 0 COMMENTS
- PERMALINK
- STANDARD POST TYPE

**A Classic Excel Problem**

In large spreadsheets if you drag formulas down too far then you are increasing the calculation time and also the chances that Excel will freeze and/or crash.

On the other hand, if you don’t drag the formulas down far enough then maybe your model doesn’t make sense.

**Why not ask Excel to tell you the answer?**

In some situations it’s possible to build a formula that would tell you in plain English

- (a) “
*yes, the formulas are dragged down far enough*“, - (b) “
*formulas are not dragged down far enough*” or - (c) “
*the formulas are dragged down 300 rows too far*“.

**Download my Excel file**

Download **here** or via **my OneDrive** (file 00069)

**Watch my YouTube video**

**What are the ingredients to my solution?**

I used these functions: **MAX,** **COUNTA, SUM** and **IF** functions,