E3{=IFERROR(INDIRECT(TEXT(RIGHT(SMALL(IF(A$3:C$6>0,ROW($3:$6)/1%+{1,2,3}*10001),ROW(A1)),4),"!R0C00"),),"")
F3=IF(E3="","",INDEX(OFFSET($A$8,MATCH(F$2,OFFSET($A$8,,SUMPRODUCT((A$3:C$6=E3)*{0,1,2}),9),),SUMPRODUCT((A$3:C$6=E3)*{0,1,2}),9),SUMPRODUCT((A$3:C$6=E3)*{1;2;3;4})))
留言
張貼留言