jamesfell1984
New Member
- Joined
- Sep 4, 2018
- Messages
- 3
Hi There,
I wonder if someone can help me?
I have a series of data (~700 rows, 5 columns) that I am looking to allocate into 5 groups using a random function and based on a series of rules / criteria that I would like to apply. I wondering if there is a simple formula that I can apply to the data series to help achieve this.
The data series is made up of 5 columns, these are:
I am looking for a function that would allow me to create 5 groups, with the group identifier populated in column F, simply "Group 1"...."Group 2" etc would be fine, where:
<tbody>
</tbody>
This sample data should you like to take a look can be found here.
Would anyone know how a formula that would allow me to do this quickly? I've been doing this manually to date and its a real bind.
I wonder if someone can help me?
I have a series of data (~700 rows, 5 columns) that I am looking to allocate into 5 groups using a random function and based on a series of rules / criteria that I would like to apply. I wondering if there is a simple formula that I can apply to the data series to help achieve this.
The data series is made up of 5 columns, these are:
- Column A - Number
- Column B - Type
- Column C - City
- Column D - Radius
- Column E - Population
I am looking for a function that would allow me to create 5 groups, with the group identifier populated in column F, simply "Group 1"...."Group 2" etc would be fine, where:
- The population / sample is split as evenly as possible across the 5 groups based on the SUM of Column E.
- There is a rule that means that the same combination of Type, City and Radius only (Columns B, C and D) cannot appear within the same group. (e.g. scenarios such as the below would see the group allocation be different for each row)
Column A | Column B | Column C | Column D | Column E |
Number | Type | City | Mileage | Population |
1 | Data | New York | 0-30 | 225 |
2 | Data | New York | 0-30 | 225 |
1 | Data | New York | 0-30 | 225 |
<tbody>
</tbody>
This sample data should you like to take a look can be found here.
Would anyone know how a formula that would allow me to do this quickly? I've been doing this manually to date and its a real bind.