Forum Discussion
Random Name Generator
Good afternoon, I work in a shop enviroment. I'm looking to create an Excel Spreadsheet to help schedule my employees. I have around 30 assembly jobs with the same amount of employees. I want to ...
Without more info - one way of doing this is to number the Activities 1-30 in the column next to the name. Assuming Employees are listed in A2:A31, in B2 add =RAND() and fill that formula down to B31. In column C add =RANK(B2,$B$2:$B$31,1) and fill that down to C31. You can then use VLOOKUP to match the number in the Activity Column with the Rank of the random number generator... or even better use INDEX and MATCH. One thing to bare in mind is that every time you open or re-calculate the sheet it will give a different rank so you may need to copy and paste the values to have a static copy, print out the list, or look at a Macro to automatically refresh, copy and paste into a history tracker. Hope that is helpful/ makes sense.