Hello, I have to create seperate examples of vehicle mileage log sheets for part of a training exercise. Currently I am doing these by hand and they take ages so I have had a go with Excel and have managed to generate the random numbers but am lost on how to get them to add up to a total and in a given ammount of entries.
The given information will have a given start and end total mileage and a given number of entries, eg start 0 end total 10455 split over 150 entries. but the 150 entries need to be within a range of 20 to 135 (obviously totalling the total 10455).
If anyone has time to offer some help I would be most grateful.
thanks, M![]()
Bookmarks