Dear Friends,
I have a Ms –Excel Sheet having list of names from rows C1 to C506, now i want to find out duplicate names in rows c2 to c506.
Please help me how to find duplicate names.
Regards
Dear Friends,
I have a Ms –Excel Sheet having list of names from rows C1 to C506, now i want to find out duplicate names in rows c2 to c506.
Please help me how to find duplicate names.
Regards
Hi Aquwap,
welcome to the forum.
Try using below formula:-
=IF(COUNTIF($C$2:$C3,$C3)>1,"Duplicate","Uniqe")
see attached:- duplicate finder.xlsx
Regards,
DILIPandey
<click on below * if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), [email protected]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks