I'm trying to count the number of workers that my managers have to interact with and I'm not having any luck. Column A is a list of projects, Column B is a list of managers, and Column C is a list of workers. I want to run a second table that calculates the number of workers that each manager has to work with. Any thoughts?
Project Name Manager Worker Alpha Ann Brett Bravo Ann Colin Charlie Ann Colin Delta Ann Dave Echo Ellen Dave Foxtrot Ellen Dave Golf Ellen Dave Hotel Ellen Colin India Ellen Colin
Manager Number of Workers Ann 3 Ellen 2
Bookmarks