Random task generator

  • Thread starter Thread starter mrothenb
  • Start date Start date
M

mrothenb

I have a list of agents who need to be assigned to several differen
tasks. I would really like to save some time by setting something u
to assign these tasks immediatly. No $ in funding for schedulin
software so it is either manually or create something.

Basically I am looking to take a list of 10 agents and have severa
cells randomly generated with a name from the agent list, thu
assigning the task fairly and with minimum time involved.
My problem is that I haven't a clue if it is possible or where t
begin.

Any thoughts or ideas would be great
Thanks
Mik
 
Mike,

You don't say much about your setup, so I don't know if this will be of any
help.

In a new column next to the agent list, enter =RAND().
Press F9 to recalculate and then sort on the RAND() column.
Each time you do that, the agents will be ordered differently and you can copy
and paste the list wherever you want it.
You may record a macro to save a few steps.

Regards,
Anders Silven
 
Enter a list of the agents from A1 to A10.

In your list of tasks to assign, create a link to this list by simply
entering in the adjoining column:
=A1
=A2
=A3
.... etc.

In B1 enter this formula:
=RAND()
And copy down to B10.

Select both lists together, A1:B10, then
<Data> <Sort>
And choose sort by column B, then <OK>.

You now have each task assigned randomly to a name.

Just resort column A and B to randomly re-assign the tasks as many times as
needed.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



I have a list of agents who need to be assigned to several different
tasks. I would really like to save some time by setting something up
to assign these tasks immediatly. No $ in funding for scheduling
software so it is either manually or create something.

Basically I am looking to take a list of 10 agents and have several
cells randomly generated with a name from the agent list, thus
assigning the task fairly and with minimum time involved.
My problem is that I haven't a clue if it is possible or where to
begin.

Any thoughts or ideas would be great
Thanks
Mike
 
For a variety of options see the Excel/Tutorials/Random Selection page
of my web site.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Back
Top