Extract a list of unique characters from a column

[ollyhughes1982]

Hi all,

I have column with a list of parkrun names in it. There’s a challenge within the parkrun community to do parkruns containing various characters. Is there a way to extract all unique characters from a column into another column? Including all letters, punctuation and special or foreign language characters etc.

Thanks,

Olly.

 

[Fluff]

Does it need to be case sensitive?

 

[ollyhughes1982]

Does it need to be case sensitive?

That’s a good question. I’m not sure about cases in other languages. I would say yes, please

 

[Fluff]

Ok, how about

=LET(u,UNIQUE(FILTER(B2:B1000,B2:B1000<>"")),UNICHAR(UNIQUE(UNICODE(MID(CONCAT(u),SEQUENCE(LEN(CONCAT(u))),1)))))

 

[ollyhughes1982]

Ok, how about

=LET(u,UNIQUE(FILTER(B2:B1000,B2:B1000<>"")),UNICHAR(UNIQUE(UNICODE(MID(CONCAT(u),SEQUENCE(LEN(CONCAT(u))),1)))))

Wow, thanks. Never heard of those UNICODE functions. I will try later this evening. Out for my 40th Birthday at the moment. Officially old! ??

 

[Fluff]

Ok & Happy Birthday ?

 

[ollyhughes1982]

Ok & Happy Birthday ?

Thanks. By 50 I might actually become half-decent at Excel ???

 

[ollyhughes1982]

Hi, @Fluff, is there a way to get this to work for a larger range, please? I keep getting a calc error when I try to do more. I forgot that I had posted this question on here originally, but have now found this feed.

Here's a link to the new one: List of unique characters from a list

Thanks.