Validation of entered data

When entering the parameters of a calculation, it is useful when we can check that the correct values are entered. This type of control serves to check whether a good type of data is entered, whether the values are in the reference range, and can be used to help when entering data into a table. In this way, Excel can also be used as a tool for completing a questionnaire with predefined answers.

Removing duplicates

When retreiving data from another application or their mass input, especially when done by more people, occurrence of repeated values is a common thing. If it’s a small amount of data, we’ll probably be able to manually remove them. However, when reviewing large tables, we can also use the Excel option that allows you to find and remove duplicates based on one or more criteria.