顯文字 依數字 (10981)


E2=OFFSET(H$1,SUM(MMULT((I$2:R$11=B2)*(I$2:R$11<>"")*ROW($1:$10),ROW(1:10)^0)),)&OFFSET(H$1,SUM(MMULT((I$2:R$11=C2)*(I$2:R$11<>"")*ROW($1:$10),ROW(1:10)^0)),)&OFFSET(H$1,SUM(MMULT((I$2:R$11=D2)*(I$2:R$11<>"")*ROW($1:$10),ROW(1:10)^0)),)


留言