Count of Unique Values in a Column of data with Comma Delimitted, Multiple Cell Values

[l1napier]

I would like to determine if there is an Excel Formula solution for counting the number of unique values in a column where cells have multiple values separated by a comma.
Please see the illustration below.

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[l1napier]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Thanks Fluff - I updated the "Account Details" with Office 365 and Windows

 

[Fluff]

Thanks for that
How about

=ROWS(UNIQUE(TRIM(TEXTSPLIT(TEXTJOIN(",",,A2:A6),,","))))

 

[l1napier]

Fluff - That did the trick Thank you so much for your very quick help!

 

[Fluff]

You're welcome & thanks for the feedback.