Changing table formulas

[AhmedIsmail759]

Hi guys,

I have a huge range of data formatted as a table, and there is some cells in a column have unique formulas (different than the main formula in this column)
So, what if i want to change the main formula in this column without affecting these unique cells?

Thanks,,,

[:) Sixthsense :)]

Please show something to us in an excel file with expected output for getting better understanding of your requirement