I love Excel tables. I've been using them more-and-more as of late.
Let's say I've created a simple table that includes cells A1:E5 and I create a formula in cell E2. Excel, in an effort to be smart, automatically transfers the formula in E2 to cells E3 - E5. Most the time, that's what I want. Sometimes, however, I want the formulas in column E to vary. Is there a way to tell Excel to not automatically transfer the formula in E2 to cells E3 - E5?
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210 (2 * 3 * 5 * 7) or 2310 (2 * 3 * 5 * 7 * 11).
The larger templa…