Count the # of occurrences in a cell based on a list

[dparnell]

Hello,

I have (i) a column in which each cell contains all of the cities in which companies have offices, and (ii) a column of specific cities that I'd like to count, if they occur in each cell.

In less abstract terms, what i am trying to do is find out how many international offices each company has. One column contains all of the cities in which a company has offices. One column has a list of all of the cities that I'd like to count. Please see the following screenshot - https://www.screencast.com/t/xhxsbqAMX

Please help!

David

 

[dparnell]

Yes - the US cities are in a "City, State" formation, so they contain a comma.

I didn't know that about the duplicate checking; which is disconcerting because I've used it so many times in the past!

I think that this going to take care of my challenge. Thanks so much for all of your help!

 

[Peter_SSs]

I think that this going to take care of my challenge. Thanks so much for all of your help!

You're welcome.

Post back with details if any further issues arise.