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
Post a Comment