识别具有相同ID和相同年龄的名称 [英] Identify names with same ID and same age
问题描述
这是我的第一篇文章,对不起,我的英文不好。
我想看看一个值的所有年龄是否一样。
如果它们不重复,或者如果值相同,那么对我来说可以。
在下面的例子中,当它是不好时,我想复制我的行,然后粘贴到另一张表(我可以处理这个部分^^)
ID年龄我的价值
pre>
-------------------
1 15不好
2 50 OK
2 50 OK
3 35 OK
1 16 NOT OK
1 15 NOT OK
提前感谢
解决方案您可以比较
COUNTIF
,它根据ID计算一个COUNTIFS
,它根据ID和年龄计算:= IF(COUNTIF($ A:$ A,$ A2)= COUNTIFS($ A:$ A,$ A2,$ B:$ B,$ B2),OK,NOT OK)
所以如果总数为每个ID与相同年龄的条目数相匹配,将显示确定。
Hi this is my first post here, sorry for my bad english.
I'd like to see if all the age of one value are the same. If they is no duplicate or if the values are the same, then it's ok to me. In the example below, when it's "NOT OK", i'd like to copy my row, then paste it in another sheet (I can deal with this part ^^)
ID Age My Value ------------------- 1 15 NOT OK 2 50 OK 2 50 OK 3 35 OK 1 16 NOT OK 1 15 NOT OK
Thanks in advance
解决方案You can compare a
COUNTIF
that simply counts based on the ID to aCOUNTIFS
which counts based on ID and Age:=IF(COUNTIF($A:$A,$A2)=COUNTIFS($A:$A,$A2,$B:$B,$B2),"OK","NOT OK")
So that if the total number of entries for each ID matches the number of entries with the same age, it will show "OK".
这篇关于识别具有相同ID和相同年龄的名称的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!