Hello,
I have data set example as follows: I want to call out the duplicate names so if A! and B1 match AND B1 and B2 match then place an X in C1 and C2. Is this possible with a formula (not VBA) or other option?
Thanks in advance!
A1 Bob B1 Jensen
A2 Bob B2 Jensen
A3 Tom B3 Allann
A4 Bill...