What can a data analyst do if they wanted to remove duplicate values in a Microsoft Excel spreadsheet?
- use VLOOKUP
- use conditional formatting
- parse the data from “text to column”
- highlight errors
| Answers Explanation & Hints:
VLOOKUP can also be used to help with data cleaning by finding duplicates. With VLOOKUP you can compare two columns (or lists) and find duplicate values. A formula is created using VLOOKUP to target the columns with the duplicate data values. |