Random drawing (Randomizer) with maximo of numbers that the result can apper

Hello Guys, please help me, all ideas are welcome.


I need to send randomly some specific task to people, (like an automatic drawing) I have the list of the Tasks and I have the % saying how many people can be assigned to do the same thing on the day I chose.

Any ideas, Please?

"=RANDBETWEEN(100,999)"

Instead of numbers (100,900) it has to be the tasks NAMES (Cleaning Toliet, Cleaning Living Room, Washing Dishes)
In addition to that I must say that 20% of the total people can be Cleaning Toilet, 30% of the amount of people can be washing Dishes and so on

the simple formula: Index + RANDBETWEEN does the job, but I need to break down the pertage of people that I need them to work at the same task

I do not think you will be able to do what you want with formulas, but the following macro should do what you want...

Please Login or Register  to view this content.

HOW TO INSTALL MACROs
------------------------------------
If you are new to macros, they are easy to install and use. To install it, simply press ALT+F11 to go into the VB editor and, once there, click Insert/Module on its menu bar, then copy/paste the above code into the code window that just opened up. That's it.... you are done. To use the macro, go back to the worksheet with your data on it and press ALT+F8, select the macro name (RandomlyAssignCleaningTasks) from the list that appears and click the Run button. The macro will execute and perform the action(s) you asked for. If you will need to do this again in this same workbook, and if you are using XL2007 or above, make sure you save your file as an "Excel Macro-Enabled Workbook (*.xlsm) and answer the "do you want to enable macros" question as "yes" or "OK" (depending on the button label for your version of Excel) the next time you open your workbook.

Hello Rick Rothstein

I am impressed, wow, I am goot at formulas but I am new to VBA, the way you wrote everything is just perfect, this is exactly what I was looking for, Can you please give me a hint of how to link the date on the cell C2 01/17/2020 and all the range from B19 down the end where the same date seats.

I believe this modification of the code I gave you earlier will do what you want (replace what I gave you earlier with this code)...

Please Login or Register  to view this content.

Actually what I wanted to do is something like this:
IF C2 = (whatever the date is) finds these dates at the range starting from B19 down the end of the colum B:
Just for you to understand what I did,
I did a pivot table for the whole year with everybody, so I can filter by date and shift, so I would say that the dates are not organized, they can be anywhere in B:B, I mean if I use the filter to organize by alphabetic order or whatever, these dates will be changing on the range but they will always be B:B

I wanted C2 to paste the info only when he finds C2 along the way, on B:B, I did not want this to overwrites what it was before,
Once the macro is done I would be able to modify and include more condition such as shift, (Early, Late, and Night)

I am very curious to see how you do it, and I became already a big fan, I am studying VBA but I am still too far to do this by myself.

Thanks