 In this training video we're going to look at removing duplicate information from a list of information. So in this example we've got row 8, 9 and 10. We've got three employees, Ronald, Lauren, Carl, who've been duplicated with their salaries in row 19, 20 and 21. So we want to get rid of the duplicates. You can do this in Excel using the feature that removes duplicates. So you just click in the data somewhere, data tab, data tools section of the ribbon, and there's a remove duplicate option. I'm going to click on it. Yeah, I want to remove the duplicates for all of these columns or anything that's duplicated for all of the columns. And now you just press OK. OK, and I said three duplicate values are found and removed, 17 are unique. So it's taken away the three from the bottom. The top ones for Ronald, Laura and Carl still remain, so to remove the second lot of duplicates. And you just click OK to accept the change. So this is how you can remove duplicates if you have lots of duplicate values. For entire rows, you need to get rid of from a list of data or data lists of information. But this completes the training video on removing duplicates using the remove duplicates feature in Excel. If you enjoyed this video, make sure you like and subscribe to our channel. Hope to see you for the next tutorial and thanks for watching.