Hello Everyone,
I need a formula to check for duplicate values in a data range.
For example if a Value in Cell C2 exists in either Column A or Column B return the value "Duplicate" else return the value "Unique".
Any ideas anyone
Thanks
Hello Everyone,
I need a formula to check for duplicate values in a data range.
For example if a Value in Cell C2 exists in either Column A or Column B return the value "Duplicate" else return the value "Unique".
Any ideas anyone
Thanks
Try this:
=IF(COUNTIF(A:B,C2),"Duplicate","Unique")
- Moo
Hi Chris,
Try using below formula:-
=SUMPRODUCT(--($A:$A=$C$1)+($B:$B=$C1))
Regards,
DILIPandey
<click on below * if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), [email protected]
I think Moo left a piece out of his formula...
=IF(COUNTIF(C:D,C8)>1,"Duplicate","Unique")
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Many Thanks Moo
worked fine.
I've starred you!!
The OP said:I took that to mean that there is a value in C2, say "Red", and if the string "Red" is found in either column A or B, the COUNT is greater than 0, meaning it is a duplicate. The >0 part isn't necessary, so I left it out.if a Value in Cell C2 exists in either Column A or Column B
- Moo
Thanks, chris.slater. Much appreciated.
- Moo
I also realized that I did'nt included Unique / Duplicate results in my above formula
Formula:Please Login or Register to view this content.
Regards,
DILIPandey
<click on below * if this helps>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks