Johnboy28
Board Regular
- Joined
- Jun 22, 2013
- Messages
- 172
- Office Version
- 365
- 2019
- 2016
- 2013
- 2010
- Platform
- Windows
Hi
Does anyone know if there is a formula that picks up namesfrom a Cell and count them?
Please see below example.
Thank you.
<colgroup><col style="width: 56pt; mso-width-source: userset; mso-width-alt: 2706;" width="74"> <col style="width: 186pt; mso-width-source: userset; mso-width-alt: 9069;" width="248"> <col style="width: 16pt; mso-width-source: userset; mso-width-alt: 768;" width="21"> <col style="width: 48pt;" width="64"> <col style="width: 40pt; mso-width-source: userset; mso-width-alt: 1938;" width="53"> <col style="width: 41pt; mso-width-source: userset; mso-width-alt: 2011;" width="55"> <col style="width: 41pt; mso-width-source: userset; mso-width-alt: 1974;" width="54"> <col style="width: 41pt; mso-width-source: userset; mso-width-alt: 2011;" width="55"> <col style="width: 38pt; mso-width-source: userset; mso-width-alt: 1865;" width="51"> <col style="width: 48pt;" width="64"> <col style="width: 40pt; mso-width-source: userset; mso-width-alt: 1938;" width="53"> <col style="width: 44pt; mso-width-source: userset; mso-width-alt: 2121;" width="58"> <tbody>
</tbody>
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 |
<colgroup><col style="width: 56pt; mso-width-source: userset; mso-width-alt: 2706;" width="74"> <col style="width: 186pt; mso-width-source: userset; mso-width-alt: 9069;" width="248"> <col style="width: 16pt; mso-width-source: userset; mso-width-alt: 768;" width="21"> <col style="width: 48pt;" width="64"> <col style="width: 40pt; mso-width-source: userset; mso-width-alt: 1938;" width="53"> <col style="width: 41pt; mso-width-source: userset; mso-width-alt: 2011;" width="55"> <col style="width: 41pt; mso-width-source: userset; mso-width-alt: 1974;" width="54"> <col style="width: 41pt; mso-width-source: userset; mso-width-alt: 2011;" width="55"> <col style="width: 38pt; mso-width-source: userset; mso-width-alt: 1865;" width="51"> <col style="width: 48pt;" width="64"> <col style="width: 40pt; mso-width-source: userset; mso-width-alt: 1938;" width="53"> <col style="width: 44pt; mso-width-source: userset; mso-width-alt: 2121;" width="58"> <tbody>
</tbody>