Hi
JAK,
To get a copy of your list with only unique values, you can use the
"Remove Duplicates" feature in Excel. Here are the steps:
- Select the column that contains your list of values.
- Click on the "Data" tab in the ribbon at the top of the Excel window.
- Click on the "Remove Duplicates" button in the "Data Tools" group.
- In the "Remove Duplicates" dialog box, make sure that the checkbox next to the column containing your values is checked.
- Click the "OK" button.
Excel will then remove any duplicate values from your list and give you a new list with only unique values.