Hsieh

¦^´_ 1# jaga0828


   

¤U¸ü (38.6 KB)

2018-1-10 10:34

Hsieh

¦^´_ 3# jaga0828
=INDEX($G$2:$G$55,MOD(INT(SUMPRODUCT(1/COUNTIFS($A$2:$A2,$A$2:A2,$B$2:$B2,$B$2:B2)))-1,COUNT($G$1:$G$55))+1)

¤U¸ü (55.08 KB)

2018-1-11 11:16

Hsieh

¦^´_ 5# jaga0828


    =INDEX($G$2:$G$55,MOD(INT(SUMPRODUCT(1/COUNTIFS($A$2:$A2,$A$2:A2,$B$2:$B2,$B$2:B2)))-1,COUNTA($G$1:$G$55))+1)

Hsieh

¦^´_ 7# jaga0828


    =INDEX($G$2:$G$55,MOD(INT(SUMPRODUCT(1/COUNTIFS($A$2:$A2,$A$2:A2,$B$2:$B2,$B$2:B2)))-1,COUNTA($G$2:$G$55))+1)