moccasinus
New Member
- Joined
- Aug 8, 2017
- Messages
- 30
- Office Version
- 365
- Platform
- Windows
Hi, is there a way to modify formula {=SUMPRODUCT(Sheet2!K$2:K$242;TRANSPOSE($B38:$IH38))} for it not to multiply all together, but to return maximum value from array Sheet2!K$2:K$242?
Been trying various ways, multiple criteria index match etc., but none seem to work
Been trying various ways, multiple criteria index match etc., but none seem to work