Skip to main content

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.

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