Challenge: Find the largest Sub-Array (7 consecutive elements...
Sort the 'totals' produced from REDUCE in descending order by the 2nd column. TAKE the top row.=LET(totals,DROP(REDUCE("",DROP(vector,-6),Accumulate),1),TAKE(SORT(totals,2,-1),1)) Patrick2788 A variation of this