PDA

View Full Version : Distribute Numbers Evenly, With Conditions



malleshg24
02-19-2018, 11:00 AM
Hi Team,
I have a data in Column A [Trade_id ] and Column B [Trade_Processor]

I take Total Count of trade from Column A,
divide it by no of person to whom I want allocate which is in colulmn G.

ex 30/4 allocate average equally, if odd extra to someone its ok,

Condition is The Trade processed by Singham, he should not get his trade for verification.

I want the result in Column C,
below is my workbook attached, please assist,

werafa
02-25-2018, 01:15 PM
Can you please clarify your question.

i understand that you want to identify a fair distribution of work.
I do not understand what your 'condition' means, nor what you wish to achieve with it

SamT
02-26-2018, 12:34 PM
Is this school homework? We have an almost identical question in
http://www.vbaexpress.com/forum/showthread.php?62108-Sharing-Interest-Dynamically

malleshg24
03-19-2018, 10:29 AM
SamT/ Werefa

Thanks for looking in my question, I am restructuring my question.In Column A I have list of team member name , and in Column J I have unique list of team member.Avg, will be 3 here, 12/4. Now in Column B, I want to paste the unique name 3 times in such a way that

Infront of bahubali - bahubali's name should not come,
Infront of Singham - Singham's name should not come, and so on,

attached is the answer snapshot, I am ok with any answer,