Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

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

user-image
Question ajoutée par Tauseef Valki , Accountant - Team Leader , pharmalink
Date de publication: 2014/07/23
Aatif Khan
par 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
par Syed Muhammad Ahtsham ul Haq Shah , Products and Real Estate Photographer , AW Group of Industries

conditional formatting

Sudarshan Das
par Sudarshan Das , Business Development Consultant , SIM Co, D2EBD

Remove duplicates (formatting)

More Questions Like This

Avez-vous besoin d'aide pour créer un CV ayant les mots-clés recherchés par les employeurs?