Columns automatically updating?

Question

Hi All,

My columns are automatically updating after excluding rows.

I want to rank a column (let's call it Column A) in a new column (Column B) .  Afterwards, I exclude rows based on some condition.  Next, in a new column (Column C), I want to rank Column A with the excluded rows.  It does this, but then Column B is updated with the excluded rows and is exactly the same as Column C.  Is there anyway around this?  Do the columns have to automatically update?

txnelson · Accepted Answer

Natalie,

I think what you need to do, is to apply the formula in column B and then then remove the formula, leaving the values, but not the formula.  You can do this interactively or in a script, if that is how you are approaching the problem.

:column B << delete formula;

Another approach would be to suppress the evaluation of the formula

:column B << Suppress Eval;