J6{=SUBSTITUTE(OFFSET(B$5,SMALL(IF(MMULT(C$6:E$10,{1;1;1})>=COLUMN(A:I),ROW($1:$5),99),ROW(A1)),)&"",LOOKUP(1,0/(J$5:J5<>""),J$5:J5),)
K6{=OFFSET(B$5,,RIGHT(SMALL(IF(OFFSET(C$6:E$6,MATCH(LOOKUP(1,0/(J$6:J6<>""),J$6:J6),B:B,)-6,)>=ROW($1:$9),ROW($1:$9)/1%+{1,2,3},9999),ROW(A1)-LOOKUP(1,0/(J$6:J6<>""),ROW($1:1))+1),2))&""
L6{=OFFSET(F$5,MIN(IF((MMULT(C$6:E$10,{1;1;1})=ROW(A1)-LOOKUP(1,0/(J$6:J6<>""),ROW($1:1))+1)*(B$6:B$10=LOOKUP(1,0/(J$6:J6<>""),J$6:J6)),ROW($1:$5),99)),)&""
依A B C順序顯示 K6{=OFFSET(B$5,,RIGHT(SMALL(IF(ROW($1:$9)<=VLOOKUP(LOOKUP(1,0/(J$6:J6<>""),J$6:J6),B:E,{2,3,4},),ROW($1:$9)/1%+{1,2,3},999),ROW(A1)-LOOKUP(1,0/(J$6:J6<>""),ROW($1:1))+1),2))&""
留言
張貼留言