![]() ![]() Click on the OK button.ħ duplicate values found and removed 6 unique values remain. We want to remove duplicates based on both columns, so all the columns are checked mark, it is also alright. Our data has headers, so ‘My data has headers’ is a correctly checked mark. ![]() And click on the Remove Duplicates command in the Data Tools ribbon.Ģ) Remove Duplicates dialog box appears. What I want is: only unique rows will be on the list all the duplicate rows will be deleted/removed from the list.ġ) Select a cell in the range. Two columns are holding some names and their locations. Related Readings 1) Remove duplicate rows based on two columns (Using ‘Remove Duplicates’ feature)Ĭheck out the following data.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |