ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

How the repetitions are removed in the column of excel sheet?

user-image
تم إضافة السؤال من قبل abdur rasheed , Network Administrator , Warid Telecom (Al-Khalej Telecom)
تاريخ النشر: 2013/07/22
Harshad Ganpule
من قبل Harshad Ganpule , Executive Accounts (EE) (Head Office) , Siemens Enterprise Communications Private Limited

In my view I would remove duplicate entries in following way (considered that Microsoft Excel2007 is in use)1) select the entire column which contains duplicate entries2) go to data, then click on remove duplicates.
This way I would remove duplicates

مستخدم محذوف‎
من قبل مستخدم محذوف‎

The method I use depends on the data set, but is you are working with a single column, I remove the repetitions in a few simple steps.1.
Sort de data set (A Column in this example) and add a title in A12.
Add in the neighbouring column a title in B1, and in B2 the formula "IF(A1=A2;"X";"")3.
Copy this formula down until the end of the data set.
All repetitions are now marked with a "X"4.
Copy column B and paste it on same spot back as values.5.
Sort the dataset (A) with the marker column (B), so that all X-es are grouped.6.
Delete all marked records.
This way you can clean up1000's of records in seconds.

Rangarajan Ramaswamy, PMP, PMI-SP, RMP, CCP
من قبل Rangarajan Ramaswamy, PMP, PMI-SP, RMP, CCP , Planning Engineer , Six Construct Ltd.

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

المزيد من الأسئلة المماثلة