Find duplicate values

[excel_learner]

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.

[Admin]

Hi,

In C2 and copied down,

=IF(COUNTIFS($A$2:$A$4446,A2,$B$2:$B$4446,9)>1,"Ye s","No")

[excel_learner]

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.

[Admin]

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

[Rajan_Verma]

It can be Use to identify Duplicates..
=COUNTIF($A$1:A1,A1)