å¦æ第ä¸ä¸ªå¾ä¸ºSheet1ï¼ç¬¬äºä¸ªå¾ä¸ºSheet2ï¼è®¾ç½®Sheet2çC:Då为æ¶é´æ ¼å¼ï¼ç¶åå¨Sheet2çC2åå
æ ¼è¾å
¥ä»¥ä¸æ°ç»å
¬å¼ï¼æCtrl+Shift+Enterç»åé®ç»æï¼ç¶ååå³åä¸å¡«å
å
¬å¼
=MOD(INDEX(Sheet1!$D:$D,SMALL(IF((Sheet1!$B$2:$B$2000=$A2)*(INT(Sheet1!$D$2:$D$2000)=$B2),ROW($2:$2000),4^8),COLUMN(A1))),1)
追é®ä½ 好 æä¹ææä½ çæ¹æ³æ°æ®é½ä¸º0äºåï¼
追çå¯è½Sheet1çæ¶é´ä¸ºææ¬æ ¼å¼ï¼å
¬å¼ä¿®æ¹ä¸º
=MOD(--INDEX(Sheet1!$D:$D,SMALL(IF((Sheet1!$B$2:$B$2000=$A2)*(INT(Sheet1!$D$2:$D$2000)=$B2),ROW($2:$2000),4^8),COLUMN(A1))),1)