Frequency Graph with Multiple values



I have a sales team spreadsheet that shows which sales person worke
with whom. Everyone has to partner with someone at least once during th

What I want to find out is who is working with who and how frequentl
they are working with the same partner.

My goal is to have solid number like:

Smith worked with Baker 3 times
Baker worked with Tilly 4 times
and so on.

I have attached a sample spreadsheet as well.

Please let me know if anyone has any ideas.

Thank yo

|Filename: Sample Worksheet


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question