LinkBack URL
About LinkBacks
How to randomly distripute 89 applications to 10 reviewers.
I am not a a freak in the (excel) sheets. So please make this simple for me!
I have 90 names of applicates.
I am looking to distripute randomly to 10 reviewers
Thank you so much in advance
How to randomly distripute 89 applications to 10 reviewers.
How to randomly distripute 89 applications to 10 reviewers.
I am not a a freak in the (excel) sheets. So please make this simple for me!
I have 90 names of applicates.
I am looking to distripute randomly to 10 reviewers
Thank you so much in advance
Hello fmwfcc1322. Welcome to the forum.
It makes things much simpler if you upload a small Excel workbook representative of what you are working with, what you mean by "... distripute randomly to 10 reviewers" and how you want those results laid out.
Dave
everybody 9 (columns J:S) or even that random (columns A:B) ?
Last edited by bsalv; 04-10-2023 at 05:42 PM.
Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Attachment 825189
Not sure if this will work
I should have clarified.
We want each reviewer to review 1/3 of the applications.
89 or 90 ???? as 90 is easier and an even distribution then see attached small macro on green button.
Torachan,
Mission statement; Promote the use of Tables, Outlaw the use of 'merged cells' and 'RowSource'.
Hi to all!
With Microsoft 365, this is really easy to do. If you delete or add a Reviewer, the formula just will do the "thing". Blessings!
Given that there are, and could be, duplicated first names, you might want to take John's formula a step further:
Formula:
Please Login or Register to view this content.
There is also a slight problem with using RANDARRAY in that it will regenerate the array whenever Excel recalculates the sheet. You might want to consider a small macro to put the formula in place and then convert the output to values:
Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Another option is to go to FILE>Options>Formulas and click on "Manual" for "Calculation options"There is also a slight problem with using RANDARRAY in that it will regenerate the array whenever Excel recalculates the sheet.
and just to shorten the formula slightly it can be:
Please Login or Register to view this content.
I love this. But I need to have all 10 reviewers review 1/3 of the applications. Any suggestions?
Hi again!
Is this that you want?
Blessings!PHP Code:=WRAPROWS(TAKE(SORTBY(A2:A90&" "&B2:B90,RANDARRAY(ROWS(A2:A90))),ROWS(A2:A90)/3),COUNTA(D1:XFD1),"")
Let me make sure I understand. So in your example, you want the 9 Reviewers to each interview 1/3. So they would all interview 30 people? So each person would interview 3 times? Or if they are assigned completely randomly, then you might have 1 person being interviewed 5 times and another 1 time. What if they were randomly put into 3 groups. Could you then take those 3 groups and assign them to 3 reviewers each?
you can make 90 interviews per reviewer.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks