Searching for unusual characters

[ollyhughes1982]

Hi,

Re this strange character 'ʷ': Is there a way that you can do a search on it specifically? I have an alphabet-related parkrun challenge worksheet that looks for all letters within parkrun names. This strange character has appeared in one of the most recent new events. 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 ASCII code or something, rather than the actually character, to prevent it looking for 'W' or 'w'?

The function that i have used up until now, that looks for the value in column A, is as follows:

=IFERROR(IF(A48<>"",XLOOKUP("*"&A48&"*",'All Completed Runs'!$C$4:$C$2003,'All Completed Runs'!$C$4:$C$2003,,2),""),"")

There is some background to this in two other previous threads:

List of unique characters from a list

List of unique characters from a list

Thanks in advance!

Olly.

 

[ollyhughes1982]

Yes, I'm disregarding case, so treating them the same would be better. Thanks, I will try this

 

[ollyhughes1982]

FIND is case-sensitive. I wasn't sure if you're counting lowercase r and upper case R as one unique character. If you're counting them as one then try.

=XLOOKUP(TRUE,ISNUMBER(FIND(UPPER(A48),UPPER('All Completed Runs'!$C$4:$C$2003))),'All Completed Runs'!$C$4:$C$2003,"")

It worked perfectly, all previous results stayed as they were. Thanks so much for your help.

 

[Cubist]

You're welcome.