I have data in the cell in this format saved in A column of excel

`[Amber,Maria,Marian,Mar]

[Maria]

[Marian,Amber,Maria]

[Maria,Marian]`

I want a filter for Maria and Marian.

how can i use some regex formula filtering Maria and Marian separately.

I am using pivot filters and want to use custom formula there

contain(A1,"Maria") will return Maria and Marian both

CodePudding user response：

=ISNUMBER(SEARCH("Maria,",SUBSTITUTE(A1:A4,"]",","))) shows TRUE if Maria is found and false if it would only be Marian, not Maria.