Template to track who sits with who and how often?

B

bluetang

I issue a work planner for a team of 17 people each week. Each person sits in
a different location each day with one other member of the team and to ensure
fairness etc... I try to sit them with a different person as well. Is there a
template that will track who sits with who and will tot up the totals for
each person - i.e David sat with Mark 5 times over the past 5 weeks, Jan sat
with Eric 2 twice, but david 3 times etc.... I'm quite new to spreadhseets
and not sure how to plot this. Any help would be gratefully appreciated.
 

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

Top