Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

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

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

conditional formatting

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

Remove duplicates (formatting)

More Questions Like This

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.