Forum Discussion
_Elwetana
Apr 12, 2024Copper Contributor
Converting 1x1 array to number
I have following formula: =let(
src_range, A2:AA21,
cur_row, A22:B22,
myFunc, LAMBDA(range, "do something with range and return a number"),
start_col, INDEX(cur_row, , 1),
en...
PeterBartholomew1
Apr 12, 2024Silver Contributor
Your formula worked correctly for me.
Not convinced by
end_col - start_col - 1
Using +1 might be better.