Forum Discussion
Formula not working - Dynamic array for subtraction
Currently I'm facing a error with the below formulas, which is giving Error "You have entered too many Argument for this function" or simply "Zero" is coming as output. Hence requesting any SME suppo...
How about this:
=LET(
rng, FILTER(BD3:BO3, BD3:BO3<>""),
len, COUNTA(rng),
last, INDEX(rng, len),
prev, INDEX(rng, len-1),
IF(last=prev, last, last - prev)
)