Excel: Count Names from Cell

Hi Does anyone know if there is a formula that picks up namesfrom a Cell and count them? Please see below example. Thank you.

Number Names Johnny Mark Dave Jason John Tina Belinda Chris Steven
3 Johnny, Mark, Dave, Jason, Dave 1 1 2 ??
5 Gavin, Mark, Peter, John
6 Tina, Belinda, Johnny, Chris, Steven
7 Tina, Johnny

This question generated 12 answers. To proceed to the answers, click here.

This thread is current as of August 14, 2014.

For more resources for Microsoft Excel