Hello,

I have a table of data that lists work schedules for the month in columns. There are 155 different schedules in total, and each column simply lists the work site for a given day:

schedules.png


What I am trying to do is write a formula that shows for each schedule (schedule a, schedule b, schedule c, etc) how frequently each person assigned to each schedule will work with each other. I am writing the schedules for my employees, and they have requested to be able to pick their schedules based on who they will work with. In other words, employee 1 and employee 2 want to work together as much as possible, but no two schedules are the same next month.

I've tried creating an array and using a countif function to narrow the result down to certain job sites, but nothing I am doing seems to be working. Any help would be appreciated.