判断同一列相同单元格数值是否一致

verna123

大神帮忙看看

xiaoai007

E列

1. =IF(COUNT(UNIQUE(IF(B$3:B$17=B3,D$3:D$17)))>1,"不一致","一致")

复制代码

F列

1. =MODE(IF(B$3:B$17=B3,D$3:D$17))

复制代码

miaojohn45

=IF(COUNTIFS(B$3:B$17,B3,D$3:D$17,D3)=COUNTIFS(B$3:B$17,B3,F$3:F$17,F3),"一致","不一致")

cyh3230

断点是否一致, 我想的可能复杂了点

我走我流

判断E列 =TEXT(COUNTIFS(B:B,B3,D:D,"<>"&D3),"不;;;")&"一致"

jisijie630

E3:

=IF(AND(IF(B$3:B$17=B3,D$3:D$17,D3)=D3),"","不")&"一致"

象山海鲜

一.

1. =IF(VARP(IF(B$3:B$17=B3,D$3:D$17)),"不",)&"一致"

复制代码

1. =IF(OR(B$3:B$17=B3>(D$3:D$17=D3)),"不",)&"一致"

复制代码

二.

1. =MODE(IF(B$3:B$17=B3,D$3:D$17+{0,0}))

复制代码