• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Incoming task allocation - excel tracker

parasarorahk

New Member
Hi

I would like to maintain an excel file where I can track and manage work allocation.

Scenario
- 3 employees
- daily tasks ranges from 0 tasks - 30 tasks a day
- Task 1 goes to employee 1
- Task 2 goes to employee 2
- Task 3 goes to employee 3
- Task 4 goes to employee 1

Is there a way this can be captured more efficiently in excel?

Regards
Paras
 

GraH - Guido

Well-Known Member
If you'd have a list of tasks , allocation can be done using MOD ( ) function, something like
=LOOKUP(MOD(ROW(A1);3);{0;1;2};{"Emp3";"Emp1";"Emp2"})

Notice I'm using EU settings, to make it work at your end look at the attached file. Please also read the forum rules.
 

Attachments

parasarorahk

New Member
If you'd have a list of tasks , allocation can be done using MOD ( ) function, something like
=LOOKUP(MOD(ROW(A1);3);{0;1;2};{"Emp3";"Emp1";"Emp2"})

Notice I'm using EU settings, to make it work at your end look at the attached file. Please also read the forum rules.
Thank you for your reply. But I am sorry I don't get how to use this formula?
 
Top