Sorry, false alarm... figured it out using countifs, unless someon has a better solution.
Sorry, false alarm... figured it out using countifs, unless someon has a better solution.
you could use something like
=IF(IFERROR(SEARCH(",",A1,1)>1,0),"yes","no")
instead of using search you could also use find. these are similar to using instr() in VBA.
=IF(ISNUMBER(FIND(",",A1)),"yes","no")
Bookmarks