• 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.

Allocating work for audit

Niyaz

New Member
Dear Members,

I have an audit file that has orders processed by users and will be audited by same users, however, the catch is the order processed by individuals will be audited by another user.
Example order 123 is processed user "A" will be audited by "B" and "B" order will be audited by "C or "A".

And the order should be equally distributed to all the users. If 1 or 2 users get more numbers because it can not evenly distribute that's ok.

please find the sample attachment, kindly help me with the coding for this requirement.

Thank You,
Niyaz
 

Attachments

vletm

Excel Ninja
Niyaz
Did You upload a correct file?
Your writing and files text do not match.
You should use same terms in both.
... and a sample result is missing with Your sample data.
 

Niyaz

New Member
Hi vletm,

Thank you for looking at this request, sorry if was not clear.

Updating the file with additional requirements.

Now the file has two tabs, tab one raw data, for which the auditors need to be allocated based on the auditor details given in column K and L.
For each product we have different auditors.

Example for Media Products is audited by users A and C. And orders completed by users A, B, C, D, E, F should be audited by A and C equally but they should not audit their own orders.
Same for Advertisement product aswell.

Please check the Sample Result Tab

Let me know if you need more information.

Thank You,
Niyaz
 

Attachments

Niyaz

New Member
Hi Vletm,

Any chance on the coding. Please advise. let me know if you need anymore details.

Thank You,
Niyaz
 

vletm

Excel Ninja
Niyaz
You read maybe the 1st and the last line from my reply
but skipped other two.
You're that who needs something.
You should offer details, which makes possible to try to do some solution.
 
Top