I’m generating Excel Workbooks that uses a Formula that utilizes the SCAN() function. The SCAN funtion needs a LAMBDA function as input. For example:
=SCAN(0, columname, LAMBDA(acc,n,acc+n))
The Workbook is created wit…...Excel Workbooks that uses a formula that utilizes the SCAN() function...show the correct value! The formula was not changed in any way...