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

  • 31 March 2022
  • 1 reply

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 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