One way...

=COUNTIF(B2,"*Gooden*")

Copy down as needed

--
Biff
Microsoft Excel MVP


"bob" wrote in message
...
B2 through B6 contain a string consisting of last names:

B2 - Jamison, Gooden, Blatche, Foye, Miller
B3 - Butler, Jamison, Blatche, Foye, Miller
B4 - Butler, Jamison, Haywood, Foye, Miller
B5 - Butler, Jamison, Haywood, Foye, Miller
B6 - Jamison, Gooden, Haywood, Foye, Miller

In column G, I want to place a formula that returns a 1 if "Gooden" is one
of names listed in column B or a zero if "Gooden" is not listed. Can
anyone
help?

Thanks,
Bob