Distribute Numbers Evenly, With Conditions

[malleshg24]

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]

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]

Is this school homework? We have an almost identical question in
http://www.vbaexpress.com/forum/show...st-Dynamically

[malleshg24]

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,