Can someone help me with a formula or code? I have 20 envelopes containing one of the following numbers (1000,750,500,250,100) totaling 9,500. I need to know how many envelopes contain each number. The only thing that I do know is there is only 1 envelope containg 1000. can anyone help me with the others?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
help
- Thread starter erenkey
- Start date
Gerald Higgins
Well-known Member
- Joined
- Mar 26, 2007
- Messages
- 9,258
This is a maths / statistical question, not an excel question.
Can you do the maths to work out the result ? If yes, post it here and there's bound to be an excel solution.
Can you do the maths to work out the result ? If yes, post it here and there's bound to be an excel solution.
Upvote
0
Gerald Higgins
Well-known Member
- Joined
- Mar 26, 2007
- Messages
- 9,258
Here's one solution, found by trial and error, but it might not be unique
1000, 1
750, 6
500, 6
250, 2
100, 5
1000, 1
750, 6
500, 6
250, 2
100, 5
Upvote
0
Similar threads
- Question
