![]() By selecting Data > Remove Duplicates and then checking or unchecking the columns you wish to purge, you can remove duplicate records.Įxcel has a built-in tool that helps delete repeated entries in your dataset.Note: The best way to remove duplicates is to remove any outlines or subtotals from your data. Select the range of cells containing duplicate values that should be removed.Finding, highlighting, and reviewing the duplicates before removal is better than removing all the duplicates straightway. Duplicate data is sometimes useful, but it often just makes the data harder to understand. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |