Forum Discussion
Solved
Max function for Spilled Range
Hello, I am struggling to resolve the following. With DA (Dynamic Array) formulas I calculate 3 columns: App: =IF(D7=1,INDEX(SORTBY($AF$15#,$AG$15#,-1),SEQUENCE(AJ11)),INDEX(SORTBY($AF$15#,$AG$1...
SergeiBaklan Do we have any idea why MAX doesn't spill? Do we know which functions spill and which don't?
If you mean to return max in each row in the array like
when MAX() has no idea you'd like to max by row or by col, by default it returns max for entire range. We need to instruct Excel additionally would we like to have max value in each row or in each column or by some more complex logic. For that BYROW, BYCOL or like functions exist.