![]() At this moment, a Sort Warning will appear.Then, from the Sort & Filter group > select Sort A to Z.First of all, we will select cell B5:B11 > go to the Data tab > select Editing.In this method, we will use the Filter tool to delete duplicates but keep one value. Related Content: How to Remove Duplicates Based on Criteria in Excel (4 Methods) Therefore, from the range of cells F5:F8, we see that duplicates are removed and only one is kept. Here, we selected cells F4:F11 in the Copy to box.Afterward, select the location on the Copy to box.We want to see the country names in another column, so select Copy to another location. ![]()
0 Comments
Leave a Reply. |