Hi all,
I manage an indoor cricket team, with a squad of 12 players. As only 8 can take the court at any one time, I will have to rotate them, and to do so fairly, I'd like to try and generate the rotation using Excel so there aren't any human errors!
Not being particularly good with Excel, I have no idea where to start other than getting the names into column A.
Obviously there will be factors such as availability, which I need to consider, but I think I will just have to do that on an ad hoc basis.
Is anyone able to suggest anything to help with this please?
Cheers