B
bob
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
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