I am a Referee in Chief for hockey and to save time, I need to find a formula for the following.
Column A1:A200 has the type of league ie Novice
Column B1:B200 has the referee assigned ie Dougal
Column C1:C200 + D1:D200 has the (2) linesman assigned. ie Dougal Bob
On a seperate page I need to now how many games each official did per division (aprox 20 divisions)
I have tried a bunch of different functions all to no avail.
If any one has a solution I would appreciate it.
Thanks,
Dougal
Column A1:A200 has the type of league ie Novice
Column B1:B200 has the referee assigned ie Dougal
Column C1:C200 + D1:D200 has the (2) linesman assigned. ie Dougal Bob
On a seperate page I need to now how many games each official did per division (aprox 20 divisions)
I have tried a bunch of different functions all to no avail.
If any one has a solution I would appreciate it.
Thanks,
Dougal