对比列中有没重复数值取值

yang_159357 · 发表于 2018-6-7 12:47

如附件，如果D列数值重复，对应的F列有“SPC”字样，则标记“New information obtained”，另外如果D列没有重复数值，
F列有“SPC”字样，也标记“New information obtained”，这个公式应该怎么写？

gykg-excel · 发表于 2018-6-7 15:10

=IF((COUNTIF($D$6:$D$11,D6)>1)+ISNUMBER(FIND("SPC",F6)),"New information obtained","")

yang_159357 · 发表于 2018-6-7 16:29

gykg-excel 发表于 2018-6-7 15:10
=IF((COUNTIF($D$6:$D$11,D6)>1)+ISNUMBER(FIND("SPC",F6)),"New information obtained","")

谢谢

tm_luox · 发表于 2018-6-11 15:53

=IF(OR(COUNTIF($D$6:$D$28,D6)>1,IFERROR(L6,0)),"New information obtained",""),不过2楼的更高明些

tm_luox · 发表于 2018-6-11 16:00

=IF(COUNTIF($D$6:$D$28,D6)+IFERROR(FIND("SPC",F6)*1,0)>1,"New information obtained","")

tm_luox · 发表于 2018-6-11 16:02

=IF(COUNTIF($D$6:$D$28,D6)+IFERROR(FIND("SPC",F6),0)>1,"New information obtained","")

鎴戜滑璁よ瘑锛 · 发表于 2018-6-23 07:37

是不是F列中只要有 SPC 就标记 New information obatains

		自动登录	找回密码
密码			免费注册