#### abberyfarm

##### Well-known Member

- Joined
- Aug 14, 2011

- Messages
- 733

Would anybody know how I could divide a number up randomly into a certain number of smaller numbers?

For example I have (1) the number of journeys and (2) the total distance travelled. I want to divide up the total distance travelled into individual journey distances.

Here is an example

Excel Workbook | ||||||||
---|---|---|---|---|---|---|---|---|

A | B | C | D | E | F | |||

1 | No. trips | total distance | Individual distances | |||||

2 | 2 | 20 | 5 | 15 | ||||

3 | 3 | 30 | 5 | 20 | 5 | |||

4 | 3 | 25 | 15 | 5 | 5 | |||

5 | 4 | 40 | 20 | 5 | 5 | 10 | ||

Sheet1 |

Thank you for your help