Hello,

I at one point in time actually did this. It may have been with someone's help here. I don't remember.

What I am trying to do for several sheets is I will have a list of a person and project they are assigned -- Mike -- Project A, etc. I would like to the right a total for all the users and a count of the projects they are assigned:
The spreadsheets were created already with the cell containing the person's name and project separated by " -- ". I can't change the sheet to have a Name column and a Project column.

excel.JPG


Can what I want to do actually be done?

Thank you,
Mike