Forum Discussion
Dynamic array not working
Good Morning all, Currently I'm facing a error with the below formulas, which is either giving "You have entered too many Argument for this function" or simply "Zero" coming as output. Hence req...
How about
=IFERROR(LET(range, BD3:BO3, filled, FILTER(range, range<>""), last, TAKE(filled, , -1), previous, TAKE(DROP(filled, , -1), , -1), IF(last=previous, last, previous-last)), "")