Final answer:
In Excel, to acquire a list of unique values you can employ the Remove Duplicates feature or, if you have Excel 365 or 2019, use the UNIQUE function. Remove Duplicates is found on the Data tab, while the UNIQUE function can be applied by typing =UNIQUE(range) in a cell.
Step-by-step explanation:
To get a list of unique values in Excel, you can use several methods, including using the Remove Duplicates feature or applying the UNIQUE function, introduced in Excel 365 and Excel 2019.
- To use the Remove Duplicates feature, first select the range of cells that contain duplicate values. Then, go to the Data tab on the ribbon and click 'Remove Duplicates'. In the dialog box that appears, make sure that the correct columns are selected and press OK. Excel will then remove duplicate values, leaving only the unique ones.
- If you have Excel 365 or Excel 2019, you can simply use the UNIQUE function. In a new cell, type =UNIQUE(range), where 'range' is the range of cells you want to extract unique values from. Press Enter, and Excel will spill the unique values into the adjacent cells automatically.
These methods will help you obtain a clean list of unique values from your data set.