Multiple Employee Name Entries in One Cell

[Guest]

I need to have excel count multiple employee name entries in one cell. I'm
currently using the COUNTIF formula. For example, if I enter Jane Doe twice
in one cell, I need the cell with the COUNTIF formula to give me a count of
2. Or, if I enter Jane Doe and John Doe in the same one cell, I need two
different cells with the COUNTIF formula to give me a count of 1 each (one
for Jane and another for John).

 

[Dave Peterson]

=Countif() counts the number of cells -- not the number of entries in that cell.

But you could use a different formula:

=(LEN(A1)-LEN(SUBSTITUTE(LOWER(A1),lower("jane doe"),"")))/LEN("jane doe")