List of unique characters from a list

[ollyhughes1982]

Hi,

This is the formula I have been using to get unique list of characters from a a list of names in column A. Is there a reason that it won't work for more than around a 1,000 rows? I get a CALC! ("CONCAT: Text too long") error. I'd like to do it for 10,000 rows.

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

Finding it a pain to keep having to repeatedly chop my list into smaller chunks.

Thanks in advance!

Olly.

 

[Fluff]

Ok, how about

=UNICHAR(UNIQUE(DROP(REDUCE("",FILTER(A2:A5000,A2:A5000<>""),LAMBDA(x,y,VSTACK(x,UNICODE(UPPER(MID(y,SEQUENCE(LEN(y)),1)))))),1)))

 

[ollyhughes1982]

Yip, that version picked it up. Thanks

 

[ollyhughes1982]

Ok, how about

=UNICHAR(UNIQUE(DROP(REDUCE("",FILTER(A2:A5000,A2:A5000<>""),LAMBDA(x,y,VSTACK(x,UNICODE(UPPER(MID(y,SEQUENCE(LEN(y)),1)))))),1)))

Re this strange character 'ʷ': Is there a way that you can do a search on it specifically? I have an alphabet-related challenge worksheet that looks for all of these letters - that's the purpose of generating this list in the first place, But, when I use my normal formula to search, for this character it is picking up the first event where the name included 'W' (Newport parkrun), rather than being blank, as I haven't yet completed the only event name that currently contains this character.

Is there perhaps a way to search on it's code, rather than the actually character, to prevent it looking for 'W' or 'w'?

 

[Fluff]

It maybe be possible, but that's a different question & so needs a new thread.