Minute 04:00 — 05:00 duplicated data is okay you know you want to get rid of that and it’s very easy to do in excel the first thing we’re going to do we’re going to go to this data tab we’re going to go right over here and we’re going to get see if there’s any duplicates in our data so we’re just gonna go up to remove duplicates it’s gonna automatically choose all of your columns to to check against so it’s gonna for from a all the way through i it’s gonna see is the exact same data in all these rows and if it is it’s going to get rid of it and so we’re going to click ok and it did find one duplicate and i’ll show you that one real quick because you know it was right here so barack obama was here twice and then i’m gonna hit control i hit control z to go back i’m gonna hit control y to go forward and it removed that that row completely Removing Duplicates now in this example you may be able to spot that with your eye but in a real data set where you have ten thousand a hundred thousand rows there’s absolutely no way you’re going to see that or very very unlikely that you are going to