Assign values based on sum of cells

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.


OrgCountsAssigned
Ravi & Co11Jyoti
Samruddh Agency14Jyoti
Gaurav Trading19Mihir
Jay Telegrams18Visarg
Total62
 

Some videos you may like

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

Watch MrExcel Video

Forum statistics

Threads
1,128,148
Messages
5,628,987
Members
416,357
Latest member
Kongoni

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top