不重复值提取.xls

不不重重复复值值提提取取解法一解法二客客户户名名称称不不重重复复值值不不重重复复值值GGGLLLMMMAAATTTKKKJJJEEEGCCCSSSECA解法一=IF(SUM(1/COUNTIF($B$7:$B$20,$B$7:$B$20)=ROW(B1),INDEX($B$7:$B$20,SMALL(IF(ROW($B$7:$B$20)-6=MATCH($B$7:$B$20,$B$7:$B$20,0),ROW($B$7:$B$20)-6,0),ROW(B1),)字符数162解法二=INDEX($B$7:$B$100,SMALL(IF(MATCH(B$7:B$20,B$7:B$20,)=ROW(B$7:B$20)-6,ROW(B$7:B$20)-6,93),ROW(A1)&字符数102解法三=IF(SUM(N(COUNTIF($I$6:I6,$B$7:$B$20)=0),INDEX($B$7:$B$20,MATCH(,COUNTIF($I$6:I6,$B$7:$B$20),),)字符数100解法三不不重重复复值值GLMATKJECS=IF(SUM(1/COUNTIF($B$7:$B$20,$B$7:$B$20)=ROW(B1),INDEX($B$7:$B$20,SMALL(IF(ROW($B$7:$B$20)-6=MATCH($B$7:$B$20,$B$7:$B$20,0),ROW($B$7:$B$20)-6,0),ROW(B1),)=INDEX($B$7:$B$100,SMALL(IF(MATCH(B$7:B$20,B$7:B$20,)=ROW(B$7:B$20)-6,ROW(B$7:B$20)-6,93),ROW(A1)&=IF(SUM(N(COUNTIF($I$6:I6,$B$7:$B$20)=0),INDEX($B$7:$B$20,MATCH(,COUNTIF($I$6:I6,$B$7:$B$20),),)