|
本帖最后由 cabcyvr 于 2017-9-18 05:13 编辑
假设Sheet1中的A列和C列共有200行(如果超过,自己把公式中的200改为你实际的范围)
Sheet 2
B1=IFERROR(INDEX(Sheet1!A:A,SMALL(IF((Sheet1!$A$1:$A$200<>"")*(MATCH(Sheet1!$A$1:$A$200&Sheet1!$C$1:$C$200,Sheet1!$A$1:$A$200&Sheet1!$C$1:$C$200,)=ROW(Sheet1!$A$1:$A$200)),ROW(Sheet1!$A$1:$A$200),"/"),ROW(B1))),"") 数组
C1=IFERROR(INDEX(Sheet1!C:C,SMALL(IF((Sheet1!$A$1:$A$200<>"")*(MATCH(Sheet1!$A$1:$A$200&Sheet1!$C$1:$C$200,Sheet1!$A$1:$A$200&Sheet1!$C$1:$C$200,)=ROW(Sheet1!$A$1:$A$200)),ROW(Sheet1!$A$1:$A$200),"/"),ROW(C1))),"") 数组 |
|