We help IT Professionals succeed at work.

If statement to find duplicate values

138 Views
Last Modified: 2017-03-30
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

CERTIFIED EXPERT
Top Expert 2010
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION

Author

Commented:
That worked. Thank you!