Formula to produce "yes" if 2 or more cells are duplicates

[ExcelFailure]

Hello,

I am after a formula or VBA that will give me the word "yes" if two or more cells in a list are duplicates.

So for instance I have the below list:

A 1 Apple 30
B 1 Banana 30
C 3 Apple 45

So I would want it to produce "yes" for row 1 and 2, as they have cells B1 the same as B2 and D1 the same as D2. But not for row 3 as that only has 1 cell that is a duplicate.

Can this be done?

[Kaper]

Use:

Please Login or Register  to view this content.

[ExcelFailure]

Thanks, but that seems to be saying yes for most of my rows, whereas only a few rows should have 2 or more duplicates?

Actually can it be changed so that all 3 lines have to be the same to be a "yes"?

[Kaper]

sorry to say so, but no_precise_description => no_universal_answer
As there is still no sample workbook with enough data to demonstrate your need next guess will be (all 3 cells in a particular record doubled somewhere in another row):

Please Login or Register  to view this content.

or may be you are only interested in column B and D? then for these two:

Please Login or Register  to view this content.