May be this...

Paste the below formula in C1 cell

=IF(COUNTIF(A:A,A1)=1,"NO DUPLICATES",IF(COUNTIF(A:A,A1)1,"DUPLICATES",""))

Copy the C1 cell formula and paste it for the remaining cells of C Column.

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"Rod" wrote:

Thanks, but I need a formula like this
=IF(MAX(COUNTIF(A2:A11,A2:A11))1,"Duplicates","No Duplicates")
but it will check two columns A and B

Help me

Thanks in advance

"Ms-Exl-Learner" wrote:

Paste the below formula in C1 cell

=IF(OR(A1="",B1=""),"",IF(SUMPRODUCT(($A$1:$A1=$A1 )*($B$1:$B1=$B1))1,"DUPLICATES",IF(SUMPRODUCT(($A $1:$A1=$A1)*($B$1:$B1=$B1))=1,"NO DUPLICATES","")))

Copy the C1 cell formula and paste it for the remaining cells of C Column.

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"Rod" wrote:

Hi all,
I have the data as shown below
col A col B
1 a
2 a
3 a
1 a
1 b
2 b
Is there any formula to find duplicates( 1st and 4th rows are duplicates)
are there or not?
I am using the sumproduct formula in supporting column C
But I need the formula in C1 which displays "Duplicates" if there are or
else "No duplicates"
Thanks in advance