Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Multiple Employee Name Entries in One Cell
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). |
#2
|
|||
|
|||
=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") Dave wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel: Clear all cell entries EXCEPT formulas? | Excel Discussion (Misc queries) | |||
Referencing a newly created worksheet | Excel Worksheet Functions | |||
up to 7 functions? | Excel Worksheet Functions | |||
Formula to return cell contents based on multiple conditions | Excel Worksheet Functions | |||
multiple entries | Excel Worksheet Functions |