假设100行，手机号在D列：表2A、D分别输入：=index(sheet!$a$1:$a$100,small(if(match(sheet!$D$1:$D$100,sheet!$D$1:$D$100,0)row($1:$100),row($1:$100),""),row(a1)))=index(sheet!$D$1:$D$100,small(if(match(sheet!$D$1:$D$100,sheet!$D$1:$D$100,0)row($1:$100),row($1:$100),""),row(a1)))数组公式，ctrl+shift+enter结束...
|
