D9:D12{=IFERROR(INDIRECT(TEXT(MIN(IF((A$1:C$1=D$8)*(COUNTIF(D$8:D8,A$2:C$3)=0),{2;3}/1%+{1,2,3})),"!R0C00"),),"")
E9:F12=SUMPRODUCT(N(+$B$2:$D$3)*($A$2:$C$3=$D9)*($B$1:$D$1=E$8))
E9:F12另解=IFERROR(VLOOKUP($D9,OFFSET($A$2,,MATCH(E$8,$1:$1,)-2,2,2),2,),"")
留言
張貼留言