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

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

متابعة

Which function is useful to remove duplicate data in given database in excel?

user-image
تم إضافة السؤال من قبل Tauseef Valki , Accountant - Team Leader , pharmalink
تاريخ النشر: 2014/07/23
Aatif Khan
من قبل Aatif Khan , Manager Compliance & Reconciliation , Kings Real Estate

This is a very vague question. First of all there is a function known as remove duplicates. This will remove all duplicates in a given selection of data. However you will have see its relevance to your sheet. This is useful if there is only one column of data. However in case of mulitple columns, other options such as concentate would help.

Syed Muhammad Ahtsham ul Haq Shah
من قبل Syed Muhammad Ahtsham ul Haq Shah , Products and Real Estate Photographer , AW Group of Industries

conditional formatting

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

Remove Duplicate function

Sudarshan Das
من قبل Sudarshan Das , Business Development Consultant , SIM Co, D2EBD

Remove duplicates (formatting)

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