Output to List as Duplicate using Excel Formulaes

[sonypsunny]

Hello


I have given below a sample table where in the 2nd Column the output is shown.


Is there anyway to display the same output using Excel Formulas?


Name Duplicate/Not


Ann Not

Steve Duplicate

Tom Duplicate

Mark Not

Steve Duplicate

Tom Duplicate

Tom Duplicate


Thanks


Sony

 

[Faseeh]

Hi sonypsunny,


With your data located in A1:A7, enter this formula in B1 and drag it down"

=IF(COUNTIF($A$1:$A$7,A1)>1,"Duplicate","Not")

..will give you required result.


Regards,

Faseeh

 

[sonypsunny]

Thanks so much !!!!