H2 {=MAX((E$2:E$11=E2)*(F$2:F$11=F2)*G$2:G$11)
C2=SUMPRODUCT((E$2:E$11=A2)*(MATCH(E$2:E$11&F$2:F$11,E$2:E$11&F$2:F$11,)=ROW($1:$10))*H$2:H$11)
D2 {=SUM(MOD(SMALL((E$2:E$11&F$2:F$11=TRANSPOSE(E$2:E$11&F$2:F$11))*TRANSPOSE(G$2:G$11)+ROW($1:$10)/1%,ROW($1:$10)*10),100)*(MATCH(E$2:E$11&F$2:F$11,E$2:E$11&F$2:F$11,)=ROW($1:$10))*(E$2:E$11=A2))
留言
張貼留言