-
1 Attachment(s)
Find duplicate values
I want to find out from the given data the repeating values for certain numbers. e.g i have seq no and divisions and if seq no is repeating for another division then say repeating. I have attached the excel file giving the data and requirment.
kindly assist.
-
Hi,
In C2 and copied down,
=IF(COUNTIFS($A$2:$A$4446,A2,$B$2:$B$4446,9)>1,"Ye s","No")
-
Thanks, but it gives yes even where 9 and 5 are not linked. e.g if you apply the formula and check seq no (JE) 2357 it has only 9 no repeat on 5. I want to mark yes for all the records where seq no (JE) is repeating with division 5 and 9 and if it is for 5 and 9 alone then NO.
-
Hi,
May be..
=IF((COUNTIFS($A$2:$A$4446,A2,$B$2:$B$4446,"5")>1) *(COUNTIFS($A$2:$A$4446,A2,$B$2:$B$4446,"9")>1),"Y es","No")
-
It can be Use to identify Duplicates..
=COUNTIF($A$1:A1,A1)