Filter in excel

[Avinash Kumar]

Hi,

Can you help me with custom filters in Excel.

I want a filter that selects the texts that ends with "?" in coulumn.

Thanks,
Avinash

 

[SirJB7]

Hi, Avinash Kumar!
Tried escaping the wildcard character "?" as "~?" (all unquoted)?
Regards!

 

[bobhc]

Good day Avinash Kumar

*? in the find will find all data ending in ?

 

[SirJB7]

@b(ut)ob(ut)hc
Hi, old dog!
Good night.
I'm afraid it doesn't work. Check this table:

List    SirJB7    b(ut)ob(ut)hc
       
a                X
?a                X
a?        X        X
a?        X      X
???        X      X
*                X
a*                X
*a              X
*?        X        X
a*?        X      X
*a?        X      X
asdf            X

Since the asterisk is the wildcard for any character your filter displays all entries but the blank cell.
Regards!
PS: Maybe one day I'll learn how to paste a range :$

 

[bobhc]

Good day old friend

Definitely not thinking right when I posted

• ~? finds only the ? character
• ~* finds only the * character
• ~~ finds only the ~ character

 

[polarisking]

*~? - finds all 6 rows ENDING in ?

 

[SirJB7]

@polarisking
Hi!
Without the leading asterisk too...
Regards!

 

[polarisking]

SirJB7, he said he wanted only those ending in "?", correct? The ~? captures the ?a value as well.

Cheers!

 

[SirJB7]

@polarisking
Hi!
I don't think so, give a look at the uploaded file.
Regards!