أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.
Hi Abdur, its very easy. Follow the steps for Excel2007 and above :-
1. Select the column or cells where you want the duplicates to be removed
2. Goto DATA tab and under Data tools you will find Remove Duplicates
3. Click Remove Duplicates and VOILA !!! the duplicates/repetitions are gone
Enjoy :)