Subscribe Bookmark RSS Feed

Columns automatically updating?

natalie_

Community Trekker

Joined:

Jan 6, 2016

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Solution

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;

Jim
2 REPLIES
Solution

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;

Jim
natalie_

Community Trekker

Joined:

Jan 6, 2016

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.