Question

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

  • 31 March 2022
  • 1 reply
  • 11 views

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

Userlevel 3
Badge +7

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

Reply