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, ...
Patrick2788 Formula 2 (57 characters) could be:
=IFERROR(BYROW(B2:J16*(B1:J15="j+"),LAMBDA(a,MAX(a))),"")