F
frankjh19701
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
week.
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 2.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=926
+-------------------------------------------------------------------
with whom. Everyone has to partner with someone at least once during th
week.
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 2.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=926
+-------------------------------------------------------------------