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?
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;
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;
Hi Jim,
Thank you so much! I assumed that would remove everything, but now that I know I can keep the values, the will help me a lot.