Count unique text values

Hello Angela
Thank you for your question

You could create a quick pivot table based on the column and use count instead of sum. This would give you a quick anser on the total unique ones in the list.

If this resolves your question, please mark it as resolved. If not, please reply with more information.

Kind regards
Cress