I was asked to analyze a very LONG list for duplicates. I tried using "Conditional Formatting" but the problem with that is that it also highlights "triplicates, etc." and NOT ONLY "duplicates" which is what I want. What I need is this: If the B2 column contains 2 identical "duplicates" (usually one below the others as in "2846 and 3445"), then I want on the C Column for it to say "True". I want the formula to skip triplicates, etc... exclusively pointing out sets of two. Thanks for any help you guys can give me on this... totally appreciated.

2846
2846


2930
2930
2930
2930
3445
3445
2778
2778
2778
2778
2778
2778

In C2:

=IF(COUNTIF($B$2:$B$15;B2)=2,TRUE,"")

Copy down.

XOR,

Thanks so much for your help. I get an error message though (see print screen).

It says: the formula you typed contains an error.

It highlights the $B$2:$B$15 reference. I copied and pasted on C2 exactly what you wrote.

Take a look here.

Attached Files

Help_Barbiro.xlsx (9.3 KB, 10 views)

Oh, I see now that I forgot to replace one semicolon with a comma.

You are a genius and I thank you for that!!!!!!
I had used Conditional Formatting to mark duplicates as False for anything greater than 2 but this is oh so much easier. Thanks for allowing me to pick your brain.

Have a terrific weekend!!!!

Barbi