- ©«¤l
- 605
- ¥DÃD
- 92
- ºëµØ
- 0
- ¿n¤À
- 648
- ÂI¦W
- 0
- §@·~¨t²Î
- windows
- ³nÅ骩¥»
- 7
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- macau
- µù¥U®É¶¡
- 2013-4-5
- ³Ì«áµn¿ý
- 2019-2-10
|
¥»©«³Ì«á¥Ñ sunnyso ©ó 2013-4-30 10:47 ½s¿è
¦^´_ 2# tku0216
A1~ A1000 = email 1 ~ email 1000
C1 ~C300 = email 1 ~ 300
¤èªk¤@
(Ctrl+Shift+ Enter)¦V¤U½Æ»s. °}¦C¸ê®Æ¦h¥i¯à·|¤ñ¸ûºC
B1 = IFERROR(INDEX(A:A,SMALL(IF(COUNTIF(OFFSET($C$1,,,COUNTA(C:C),),OFFSET($A$1,,,COUNTA(A:A),))=0,ROW(OFFSET($A$1,,,COUNTA(A:A),)),""),ROW(1:1)),1),"")
¤èªk¤G
»²§UÄæD, µª®×ÄæE;¦V¤U½Æ»s
D1 = IF(COUNTIF(OFFSET($C$1,,,COUNTA(C:C),),A1)=0,ROW(A1),"")
E1 =IFERROR(INDEX(OFFSET($A$1,,,COUNTA(A:A),),SMALL(D:D,ROW(A1)),1),"")
|
|