the much simpler way to get the number of unique values in an Excel column is through a filter. Although you will end up ...

You need to make a new column to ... use Microsoft Excel or Google Sheets to do that. After that, select a cell where you want to display the number of all comma-separated values.