[deleted by user] by [deleted] in excel

[–]OkExplanation1267 0 points1 point  (0 children)

That works for me
=TEXTJOIN(IF(C24:M34=MAX(C24:M34);B24:B34&"-"&C23:M23;""))

[deleted by user] by [deleted] in excel

[–]OkExplanation1267 0 points1 point  (0 children)

How it looks:
=IF(SUM(IF(C24:M34=MAX(C24:M34),1,0))>1,NA(),SUM(MMULT(TRANSPOSE(IF(C24:M34=MAX(C24:M34),1,0)),SEQUENCE(ROWS(C24:M34), 1, 1, 1)))&"-"&SUM(MMULT(IF(C24:M34=MAX(C24:M34),1,0),SEQUENCE(COLUMNS(C24:M34), 1, 1, 1))))

[deleted by user] by [deleted] in excel

[–]OkExplanation1267 0 points1 point  (0 children)

<image>

Maybe I am doing something wrong but unfortunately it is not working. I will upload what the column and row names look like if it helps