Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Excel Auto Assignment

Options
  • 13-11-2013 4:19pm
    #1
    obriendj
    Registered Users Posts: 413 ✭✭


    Hi There

    I am not sure if this is the best forum for this topic but I am looking for a little advice on how to create an excel database to assign resources to tasks

    Let me explain by using an example

    There are 5 Tasks to be done - Cut Grass / Clean Sink / Make Beds / Wash Dog / Iron Shirts
    and 5 people. Tom / John / Sam / Dave / Paul

    and some people can do some chores while others can do others - as shown here.

    Grass Beds Dog Iron Sink
    tom x x x
    john x x x
    sam x x x
    dave x x x
    paul x x x

    So the result could be something like this

    Tom - Cut Grass
    John - Clean Sink (john is the only person that can do this task)
    Sam - Make Beds
    Dave - Wash Dog
    Paul - Iron Shirts

    I would like excel to return results like this or similar automatically. Can I use a formula in Excel or another program completely to assign a person to each task?

    Is this something anyone has done before?

    Thanks in advanced.


Advertisement