Hello,

You could adjust the formulas manually to compensate. Have you tried
the Consolidation feature? Or "Group and outline" on your columns?


HTH,
JP


On Oct 19, 5:46 pm, Steve wrote:
Is there any special way to do it formula-wise?



"Gary Brown" wrote:
copy the formulas over 3 columns then delete the middle 2 columns.
For example, copy the fomulas in Col A to Col D then delete Col's B and C.
--