Expanding the range
Some of the sheets I apply this formulas to has more and some has less rows. Can I not just go in the formula and change the range ($d$2:$d$69) just change the 69 to say 300 and the other corresponding parts to expand for more rows in other sheets. I tried that and now the data returns as Zero or extremely off.
|