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?