E2:N16=IFERROR(VLOOKUP($D2&E$1&"号",IF({1,0},$B$2:$B$16,$A$2:$A$16),2,),"")
Q2:Q16 {=INDEX(D$2:D$16&E$1:N$1&"号",SUM(COUNTIF(P2,E$2:N$16)*ROW($1:$15)),SUM(COUNTIF(P2,E$2:N$16)*E$1:N$1))
另解Q2:Q16 {=SUBSTITUTE(TEXT(SUM((E$2:N$16=P2)*(ROW($1:$15)/1%+E$1:N$1)),"0排00号"),"排0","排")
留言
張貼留言