How to Distribute Data Equally Among specified People .

earthworm

Active Member
Joined
May 19, 2009
Messages
368
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
 

Some videos you may like

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

Watch MrExcel Video

Forum statistics

Threads
1,113,978
Messages
5,545,310
Members
410,675
Latest member
DLongmountain
Top