Dupplicates

  • Thread starter Thread starter Eva
  • Start date Start date
E

Eva

Hi
I have in column A the data. In column B I would like to set the formula
that check if there are dupplicates. I tried this =COUNTIF(B$1:B2,B2)>=2 but
it doesn't show me the first item that has dupplicates. Do you know how to
solve this problem?
Thanks
 
You said you have data in ColA.....In ColB cell B1 try the below formula and
copy down as required.

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

If this post helps click Yes
 
Back
Top