mabubakerali
New Member
- Joined
- Feb 23, 2016
- Messages
- 28
Hi, i was having an issue related to my job so i just explain that straight,
I have written a number in cell a1 lets say its 200000, now i want excel to display random numbers in cell b1,b5,b10 and the sum of them must be equal to the number specified in a1 which is 200000..
Is there any way to do that since the workload is big and it would be of great help
I have written a number in cell a1 lets say its 200000, now i want excel to display random numbers in cell b1,b5,b10 and the sum of them must be equal to the number specified in a1 which is 200000..
Is there any way to do that since the workload is big and it would be of great help