Dupplicates

[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

 

[Jacob Skaria]

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

 

[T. Valko]

If this is your data:

A1: 1
A2: 1
A3: 2
A4: 3
A5: 3

What results do you expect?

 

[Eva]

Works. Thank you very much!
Eva