I want to send a specific email to people who have signed up for my free stuff, but in different email from the people that have paid. It's quite important, I do this quite a bit for my subscription service. What I'd like to do after that is, just to kind of highlightanything, so- that might be all you need, and you can finish this video, but let's say we want to just double check. I know there's four, so it's kind of done it okay. The easiest one is just to remove the ones, go to 'Data', and let's go to 'Remove Duplicates'.
It won't do that if you've got blank spaces in any of these rows.
What you can do is click anywhere in your data set, and go 'Control A'. Before we had to kind of click this first one, go down here, hold 'Shift'. And we can do that now that we've cleared our blank lines. So what we need to do is select the whole data set. It might be that they got a time stamp of when they were imported so there's two different ways we're going to do this. They're exactly the same except they got different times. But there's another one down here with'Haty Chavez'. There's going to be an instance though where- these ones are easy to find because they're exactly the same. I've definitely got some in here, I can see a couple right there.There's a 'Leslie Glover', and they're exactly the same, and I want to remove them, but it's a big long list, I want to go and automatically check it. It's a good way to check to make sure you haven't got duplicates. Hi there, in this video we're going to look at removing duplicate contents.