按照特殊条件去重复值

讨厌的毛毛虫

您好，365函数在wps用不上，还有其他办法吗

亿佳装饰

=INDEX(G:G,MIN(IF(COUNTIF(I$7:I7,IF(LEFT(G$8:G$12)="甲",G$8:G$12,"")),99,ROW($8:$12))))&""

舒服就叫

=INDEX($F$8:$F$12,MATCH(IFERROR(IF(SUM(IFERROR(FIND("甲",INDEX($G$8:$G$12,SMALL(IF(MATCH($G$8:$G$12,$G$8:$G$12,)=ROW($1:$5),ROW($1:$5),),ROW(A1)))),""))>=1,INDEX($G$8:$G$12,SMALL(IF(MATCH($G$8:$G$12,$G$8:$G$12,)=ROW($1:$5),ROW($1:$5),),ROW(A1))),""),""),$G$8:$G$12,)) 三键结束

医养容

=IF(FIND("甲",OFFSET($G$7,MATCH(0,COUNTIF($J$7:J7,$G$8:$G$12),0),)),OFFSET($G$7,MATCH(0,COUNTIF($J$7:J7,$G$8:$G$12),0),),"")我的麻烦点。。。。不好意思

片儿蓝

I8{=INDEX(F:F,SMALL(IF((LEFT(G$8:G$13)="甲")*(COUNTIF(I$7:I7,F$8:F$13)=0),ROW($8:$13),99),1))&""

樊而已

=IFERROR(INDEX(G:G,SMALL(IF((MATCH($G$8:$G$12,$G$8:$G$12,)=ROW($1:$5))*ISNUMBER(FIND("甲",$G$8:$G$12)),ROW($8:$12)),ROW(A1))),"")

数组公式下拉

剧中人

=UNIQUE(FILTER(G8:G12,ISNUMBER(FIND("甲",G8:G12))))

曹东伟

I8{=INDEX(G:G,SMALL(IF((LEFT(G$8:G$12)="甲")*(COUNTIF(I$7:I7,G$8:G$12)=0),ROW($8:$12),99),1))&""

容润创

=INDEX($G$8:$G$1000,SMALL(IF(ISNUMBER(FIND("甲",$G$8:$G$12)),IF(MATCH($G$8:$G$12,$G$8:$G$12,)=ROW($G$8:$G$12)-7,ROW($G$8:$G$12)-7,100)),ROW(A1)))&""
数组公式下拉

即墨晓航

=IFERROR(INDEX(G:G,SMALL(IF((MATCH($G$8:$G$12,$G$8:$G$12,)=ROW($1:$5))*ISNUMBER(FIND("甲",$G$8:$G$12)),ROW($8:$12)),ROW(A1))),"")

数组公式下拉