If statement to find duplicate values

Michael Bradley
Michael Bradley used Ask the Experts™
I have a name in column A and item numbers in column H. I need to know if the name in column A as duplicate item numbers in column H. A brief example is below:

A                         H
Tom                   12
Tom                   10
Tom                   12
Brad                  10
Joe                     11
Joe                     13

Ideally, I would like for the formula to be in a different column and read "Yes" if Tom, Brad, or Joe had a duplicate number in column H and "no" if all values in H were unique.
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2010
This simple formula seems to do it. TRUE = unique name/value pair; FALSE = not unique.


Update your ranges accordingly.


That worked. Thank you!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial