讨厌的毛毛虫 发表于 2021-11-15 02:37:35

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

亿佳装饰 发表于 2021-11-17 01:39:30

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

舒服就叫 发表于 2021-11-17 18:30:22

=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,)) 三键结束

医养容 发表于 2021-11-18 04:17: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),),"")我的麻烦点。。。。不好意思

片儿蓝 发表于 2021-11-20 00:26:04

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))&""

樊而已 发表于 2021-11-21 12:54:45

=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))),"")

数组公式下拉

剧中人 发表于 2021-11-27 23:38:41

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

曹东伟 发表于 2021-12-1 02:09:57

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))&""

容润创 发表于 2021-12-5 05:55:34

=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)))&""
数组公式下拉

即墨晓航 发表于 2021-12-5 18:13:03

=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))),"")

数组公式下拉
页: 1 [2] 3 4
查看完整版本: 按照特殊条件去重复值