mihir_joshi01
New Member
- Joined
- May 20, 2013
- Messages
- 6
Hello,
I need to assign a row based on the sum of the cells, I know my question is confusing but below is an example of what I want.
Column A has organization names and column B has line counts, now I want to divide organization names based on Sum of Column B that should almost equally divide amongst 3 team members.
so here the sum is 62 and I have 3 workers to work on so if its equally distributed it will be 62/3 i.e. 20.67, so we cant distribute equally so it should distribute something like what is seen below
so I need an excel formula to work to distribute automatically rather than manually assigning the rows.
I need to assign a row based on the sum of the cells, I know my question is confusing but below is an example of what I want.
Column A has organization names and column B has line counts, now I want to divide organization names based on Sum of Column B that should almost equally divide amongst 3 team members.
so here the sum is 62 and I have 3 workers to work on so if its equally distributed it will be 62/3 i.e. 20.67, so we cant distribute equally so it should distribute something like what is seen below
so I need an excel formula to work to distribute automatically rather than manually assigning the rows.
Org | Counts | Assigned |
Ravi & Co | 11 | Jyoti |
Samruddh Agency | 14 | Jyoti |
Gaurav Trading | 19 | Mihir |
Jay Telegrams | 18 | Visarg |
Total | 62 |