Dupplicates

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
 
J

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

T. Valko

If this is your data:

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

What results do you expect?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top