H2:H21{=IFERROR(VLOOKUP(ROW(A2)-LOOKUP(1,0/(G$2:G2<>""),ROW($1:1))&LOOKUP("座",G$1:G2),IF({1,0},COUNTIF(OFFSET(B$2,,,ROW($1:$20)),B$2:B$21)&B$2:B$21,C$2:C$21),2,),"")
不用 VLOOKUP{=INDEX(C:C,SMALL(IF($B$2:$B$70=LOOKUP("座",G$1:G2),ROW($2:$70),4^8),ROW()-LOOKUP(2,0/(G$2:G2>0),ROW($1:1))))&""
留言
張貼留言