Microsoft Excel 69 Removing Duplicate Cell Data

SimpleTutorials

Microsoft Excel is a powerful spreadsheet application used for organizing, analyzing, and visualizing data. In this course, you will learn the essential skills you need to get started and become confident in using Excel.  In this video lesson, we will learn about Removing Duplicate Cell Data in Microsoft Excel  You can access the entire Microsoft Excel Course in the following playlist: https://www.dailymotion.com/playlist/xa9hywmicrosoft

Transcript

00:00so over here you can see that I have some data right here and they have duplicates right here

00:11just like this let's say what I want to do is I want to go ahead and remove off the duplicates

00:17so to do that you can go ahead and select out the table right here and then what you can do is you

00:22can go around over here onto the data tab and then what you can do is to remove out duplicates on the

00:29table simply click on remove duplicates so now what you want to do is now remove duplicates in

00:35let's say for example by taking in certain data right here in my case I'm going to go ahead and

00:43use name as the data reference right here and press ok once you do that you can see that it found two

00:50duplicates right here and simply went ahead to remove it and this is simply how you can go ahead

00:55and remove out duplicate datas inside of microsoft excel so hope you found this video useful be

01:03sure to hit the like button don't forget to share this out with your friends and family

01:07and for more contents like these do follow simple tutorials

Category

Transcript

Be the first to comment

Recommended