Hi all, if you are able to help with this query that would be brilliant!......
I am generating a personal tutor spreadsheet to randomly allocate staff tutors to students. I have figured out the basic RANDBETWEEN formula (=INDEX($D$2:$D$21,RANDBETWEEN(1,ROWS($D$2:$D$21)),1)) - where the tutor names are D2:D21 - however, I would like to throw a condition into the mix as not all tutors have the same tutee capacity.
So, for example in the attached (using anonymous data), there are 200 students and 20 staff members; each staff member has a different capacity on the number of students they can tutor. I can create the random tutor allocation in column B but I'm not sure how to work column E (the tutor capacity) into the formula.
Any ideas?
Many thanks
Nikki
Bookmarks