How to keep Formulas in excel from moving with columns when inserting.

[BenGrobler]

I have a formula that starts in Column"O" , each time i process data that is captured in Column "O" then a new column is inserted for the next data.
My Formula is =COUNTIF(O4:XFD4,"Cool") after inserting the new column my formula is =COUNTIF(P4:XFD4,"Cool")

i need it to stay the same after inserting a new column?

 

[Joe4]

have no idea what an anhor column is i am very new to this, please explain how to do this? please please

I already explained this back in post 7. It is pretty simple. Just insert a blank column, hide it, and update your code to start insert new columns AFTER that column, but make sure that your formulas reference this hidden column as your starting column. Then inserting new columns after that will not change the starting column in your formulas.

 

[BenGrobler]

I already explained this back in post 7. It is pretty simple. Just insert a blank column, hide it, and update your code to start insert new columns AFTER that column, but make sure that your formulas reference this hidden column as your starting column. Then inserting new columns after that will not change the starting column in your formulas.

thank you i got it it works perfectly thanks

 

[Joe4]

You are welcome.