How to determine if a cell contains a comma

alderman

New member
Joined
Jan 23, 2014
Messages
19
Reaction score
0
Points
0
I would like an equation that can identify if there is a comma in a cell

For example,

"red" would return "no", but "red, yellow" would return "yes"
 

alderman

New member
Joined
Jan 23, 2014
Messages
19
Reaction score
0
Points
0
Sorry, false alarm... figured it out using countifs, unless someon has a better solution.
 

Simi

New member
Joined
Feb 10, 2012
Messages
190
Reaction score
0
Points
0
Location
Utah, USA
Excel Version(s)
Version 2002 Build 12527.20194
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.
 
Top