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