Skip to main content
Question

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

  • March 31, 2022
  • 1 reply
  • 79 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
    Most Valuable Pathfinder
    Forum|alt.badge.img+18
    • Tamil Arasu10Most Valuable Pathfinder
    • Most Valuable Pathfinder
    • March 31, 2022

    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_
    Terms & ConditionsCookie settingsAccessibility statement