Forum Discussion
rybnz
Mar 31, 2023Copper Contributor
How to workaround circular ref in array formula?
Trying to make an excel table auto calculates when new row as been added Column A, 1 5 -7 6 Column B would be the sum of the value in Column A of the current row + the value of column B from ...
SergeiBaklan
Mar 31, 2023Diamond Contributor
Main question are there blank cells within the range in column A or not.
- rybnzApr 01, 2023Copper Contributor
No blank cells, all data are filled from top to bottom in column A
- SergeiBaklanApr 02, 2023Diamond Contributor
rybnz when any of above works