That very command is found on the Data tab in the Data Tools group. The hardest part is finding the command to do it! In your spreadsheet, many ingredients may be duplicated several times. Garlic is an ingredient in spaghetti bolognese, chicken and ginger, and so on. Imagine, for example, that you are writing a shopping list and are copying and pasting ingredients from several recipes into an excel spreadsheet. The ability to remove duplicate entries from a list is a useful one, and one that can be used in a variety of every day situations.
0 Comments
Leave a Reply. |