If statement to find duplicate values

Michael Bradley
Michael Bradley used Ask the Experts™
on
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.
Comment
Watch Question

Do more with

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

=COUNTIFS($A$1:$A$6,A1,$H$1:$H$6,H1)=1

Update your ranges accordingly.

Author

Commented:
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