Finding Maximum Values for each row using “ArrayFormula” from data table.
=ARRAYFORMULA(BYrow(A2:D, LAMBDA(row, MAX(row))))Finding which columns has Maximum Value using “ArrayFormula” from data table.
=ARRAYFORMULA(BYROW(A2:D, LAMBDA(row, INDEX({"A", "B", "C", "D"}, MATCH(MAX(row), row, 0)))))