I have a list of cells that contain a list of names. Some cells have multiple names separated by commas.
Cell A1: Andrew
Cell A2: vanessa, christine, charlotte
Cell A3: Karl, Joe, Jason, Andrew, jonathan
etc...
I would like a count of how many names in a range of cells in column A (such as A1:A350)
I do not have a list of all names to reference as there are new ones being added all the time.
I was able to find a formula that counted how many names in each cell:
=LEN(A2)-LEN(SUBSTITUTE(A2,",",""))+1
This would tell me there are 3 names in cell A2, but I want the count of all names from a range of cells in column A (such as A1:A350)
Cell A1: Andrew
Cell A2: vanessa, christine, charlotte
Cell A3: Karl, Joe, Jason, Andrew, jonathan
etc...
I would like a count of how many names in a range of cells in column A (such as A1:A350)
I do not have a list of all names to reference as there are new ones being added all the time.
I was able to find a formula that counted how many names in each cell:
=LEN(A2)-LEN(SUBSTITUTE(A2,",",""))+1
This would tell me there are 3 names in cell A2, but I want the count of all names from a range of cells in column A (such as A1:A350)