Question

how can i put a formula in a column in excel in AA v11?

  • 31 March 2022
  • 1 reply
  • 45 views
Y

I am trying to put a formula in a cell and therefore in the whole column. For example: "=COUNT.IF(A:A; A:A") but when I put it in excel with set value of cell and in excel I get something like this: '=COUNT.IF(A:A; A:A; A:A) with the quotation mark in front.

 

And to put the formula in a column, just put a loop: Each row in excel dataset?

 

Thanks & regards.

1 reply

Tamil Arasu10
Rank
Userlevel 5
Badge +11

You can use a set value on a particular cell and update the formula directly. might be you have seen the single quotes in the code which is auto-generated by the AA itself

_Tamil_

Reply


Terms & ConditionsCookie settings