New answers tagged

0

FILTER is the way to go, but you need to combine it with ARRAYFORMULA: =ARRAYFORMULA(JOIN(",",FILTER(C$1:Z$1,C2:Z2=max(C2:Z2)))) (the $ signs make it easy to autofill the formula)


Top 50 recent answers are included