Excel: find 'a' or 'b' in a cell -


using 'find' formula in excel, possible find either 'a' or 'b' in cell (without using vba)?

for ex;

a1 = 'west 1' 

i tried find(or("1","2"),a1) threw error.

you can use array formula returns first position of character list:

=min(iferror(find({"1","2","3"},a1),"")) 

press ctrl+shift+enter evaluate it.

it returns 0 if nothing found.


Comments

Popular posts from this blog

javascript - Count length of each class -

What design pattern is this code in Javascript? -

hadoop - Restrict secondarynamenode to be installed and run on any other node in the cluster -