How to put the condition in advance filter in msexcel?

What should be criteria for value where cell  value is like A+y or Ay or B+y or By
searchsanjaysharmaAsked:
Who is Participating?
 
krishnakrkcCommented:
Hi

may be..

=SUM(INDEX(--ISNUMBER(SEARCH({"ay","by"},SUBSTITUTE(A2,"+",""))),0,0))

Kris
0
 
searchsanjaysharmaAuthor Commented:
ok
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.