![]() ![]() If you compare it with the sample data you will notice that James, Olivia, and Emma these three duplicate names have been removed. Now click OK again and we will get the following result. In this scenario, it has found only three like the following image. Now click OK.Īfter clicking OK in the dialogue box, now, Excel will tell us how many duplicate names it has found. Now, a dialogue box will pop up like the image below.Īs we are just removing duplicate names, that’s why we have to uncheck the rest of the two columns States and Occupation as shown in the above picture. Now click on the Data tab and select Remove Duplicates. Excel can understand the range for you automatically. Without any further ado, let’s jump into this,įirst, click on any cell or specific range in the data set. To remove repeated entries Excel has a special tool called Remove Duplicates in the Data tab. ![]() Method 1: Remove Duplicate Names in Excel using the Remove Duplicates FeatureĮxcel has so many built-in tools to help you perform different kinds of Arithmeticand Logical operations. 7 Simple Methods to Remove Duplicate Names in Excel
0 Comments
Leave a Reply. |