B8:B16=IFERROR(SUBSTITUTE(T(OFFSET(B$1,SMALL(IF(MMULT((C$2:I$4>0)*(C$1:I$1=C$1),ROW(1:7)^0)>={1,2,3},{1;2;3}),ROW(A1)),)),LOOKUP(1,0/(B$7:B7<>""),B$7:B7),),"")
C8:E16{=INDIRECT(TEXT(SMALL(IF($C$2:$K$4>0,{2;3;4}/1%+COLUMN($C:$K),999),ROW(A1)*3-3+COLUMN(A1)),"!R0C00"),)&""
留言
張貼留言