.. Freeze cols B to F with an "in-place" copy n paste special as value
"Freeze" means to remove the formulas and preserve the underlying calculated
values returned. An "in-place" copy n paste special as values means to copy
the formulas range, then to overwrite the same formulas range with a "Paste
special" as values, which accomplishes "Freezing". Trust that clarifies it
better.

Btw, I left the expression intentionally unsimplified arithmetically so that
it is easier to see the underlying pattern, which aids understanding how it
works, and from there, potential cross application.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,500 Files:370 Subscribers:66
xdemechanik
---