彙整非空白 (12694)

F3{=INDEX(A:A,SMALL(IF(B$2:D$4>0,{2;3;4},9),ROW(A1)))&""

G3{=INDEX($1:$1,RIGHT(SMALL(IF(B$2:D$4>0,{1;2;3}/1%+{2,3,4},999),ROW(A1))))&""

H3=IF(F3="","",SUMPRODUCT((A$2:A$4=F3)*(B$1:D$1=G3)*B$2:D$4))



留言