How to Distribute Data Equally Among specified People .

earthworm

earthworm

Well-known Member
Joined
May 19, 2009
Messages
759
Office Version
  1. 2019
  2. 2016
Platform
  1. Windows
Hi,


I Have 10 People


Among 10 People I want to distribute the Numbers 1-10 Randomly between them . How to distribute them. Also the Number should not repeat .


This is a small example which I am quoting . I have a data set of 1200 . And I want to Distribute 1200 Data among 3 / 4 People .
The Data of 1200 Should be distributed equally among 3 / 4 People and Number should not be duplicate .


Please help
 

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.
Sort by date Sort by votes
You must log in or register to reply here.

Similar threads

L
  • Question
Finding the minimum cost for supply&demand distribution
Replies
0
Views
107
Legacy 143009
L
F
  • Question
Rounding values to 2 decimel while keeping total 100%
2 3 4
Replies
38
Views
388
awoohaw
awoohaw
B
  • Solved
VBA Help - Same Function needed for multiple sheets
Replies
2
Views
246
birdman15
B
A
  • Question
Show Data Validation Lists in Next Row of Table
Replies
0
Views
444
AndyPandy27
A
B
  • Question
Assign slots equally among employees with same assessment date
Replies
4
Views
207
bourdainsmoke
B

Forum statistics

Threads
1,215,097
Messages
6,123,077
Members
449,094
Latest member
mystic19

Share this page

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
Back
Top