In my flow, I have a step that writes to an active cell.
“Write the value ‘=Max(IF(B:B=B’LoopIndex’,C:C)) into cell in column ‘FirstFreeColumn’+1 and row ‘LoopIndex’ of the Excel Instance”
However, when I check the spreadsheet, in the first argument of the IF statement “@B:B” appears. This changes the functionality of the statement-how can I adjust either my flow or my excel settings to stop this behavior?

Report
All responses (
Answers (