|
G2复制以下公式,下拉;
=INDIRECT(TEXT(SMALL(IFERROR(IF(((MID(--$A$2:$E$2001,8,2)=RIGHT(--$A$2:$E$2001,2))+(MOD(MID(--$A$2:$E$2001,8,2),11)=0)*(MOD(RIGHT(--$A$2:$E$2001,2),11)=0)+(MOD(RIGHT(--$A$2:$E$2001,4)-123,1111)=0)+(MOD(RIGHT(--$A$2:$E$2001,4)-3210,1111)=0)+(--RIGHT(--$A$2:$E$2001,4)=0)),ROW($A$2:$E$2001)*10+COLUMN($A$2:$E$2001)),""),ROW(A1)),"r0c0"),)
|
|