Forum Discussion
Formulas Challenge for 365
Thank you for reading this post! I propose a formulas challenge (The shorter the better). Attached is a workbook in need of two formulas. I have solutions for each (Formula 1 is 66 characters, ...
=DROP(DROP(REDUCE("", SEQUENCE(ROWS(A1:J16)/2)*2 - 1, LAMBDA(x,y, LET(
f, LAMBDA(e, CHOOSEROWS(B1:J16, e)),
VSTACK(x, MAX(IF(f(y) = "j+", f(y+1))), "")))), 1), -1)