Bayt.com

Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

What do these navigation "Data + Remove Duplicates" do in Excel?

Removes duplicate values from your selected sheet.

Microsoft Excel
user-image
Question added by Zafar Iqbal , Teacher (Pak Studies) Subject Specialist , Home Tutor
Date Posted: 2013/09/23
Upvote (9) Views (14) Followers (4) Answers (4) Report Question
Write an Answer
Register now or log in to answer.
Nitin Gupta, ACA
by Nitin Gupta, ACA , FP&A , Rockwell Automation

Refer below link

 

https://www.google.com/url?sa=t&rct=j&q=&esrc=s&source=web&cd=3&cad=rja&ved=0CD4QFjAC&url=http%3A%2F%2Fspreadsheets.about.com%2Fod%2Fdatamanagementinexcel%2Fss%2F-excel-2010-remove-duplicates-tutorial.htm&ei=rIlnUui4D7Sv4AP8nIGoDA&usg=AFQjCNFyoX_Kibf2Pc8yjQkJzSf2TOGAYg&sig2=jeukQBbYRv7_H2lHLTMG8w&bvm=bv.,d.dmg

Zafar Iqbal
by Zafar Iqbal , Teacher (Pak Studies) Subject Specialist , Home Tutor

Thank you all for participation in answering this question.  Yes agreed we can spend our weekend at bayt.com by participation in question/answer session.

mbarek lamjarrad
by mbarek lamjarrad , programmeur d'applications , Administration de la Défense Nationale

Removes duplicate values from selected sheet

Payam Hamidi
by Payam Hamidi , Technical Manager , UIS

Hi,

A very intresting button i use a lot. When you select number of cells and push this button all the duplicate items are removed and only of instance of each is kept like if your slection is :A,A,B,B,B,C.C,D after applying this you will have A,B,C,D and all the other cells will be blank.

Write Your Answer
More Questions Like This

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

Get Help