I am new to excel formulas, so need help with how to count up the number of names in each cell in my table, if anyone cane help? ie: 7 names in cell 1, 2 names in cell 2, 4 names in cell 3
Cell 1 Cell 2 Cell 3
Paul, Jane, Susan, John, Simon, Jill, Jack, |
Andrew, Karen |
Amy, Alfie, Liam, Nina |
Many thanks |
|
By: Sandra