lmciciosr84
New Member
- Joined
- Mar 4, 2020
- Messages
- 27
- Office Version
- 365
- Platform
- Windows
- MacOS
I need a formula or a way to look at all the values and tell me which ones add up to the value to find any help would be appriciated? thanks
-
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.
Formula Help
- Thread starter lmciciosr84
- Start date
Joe4
MrExcel MVP, Junior Admin
- Joined
- Aug 1, 2002
- Messages
- 72,286
- Office Version
- 365
- Platform
- Windows
Excel has a feature called "Solver" designed for precisely that purpose.
Here is one article about it, though there are many more out there on the net: Find all combinations of numbers that equal a given sum in Excel
Here is one article about it, though there are many more out there on the net: Find all combinations of numbers that equal a given sum in Excel
Upvote
0
lmciciosr84
New Member
- Joined
- Mar 4, 2020
- Messages
- 27
- Office Version
- 365
- Platform
- Windows
- MacOS
I was working with this exact website before I posted here and I have tried the solver part and it has been going for about 30 minutes now with no results and I also tried the coded version and it gives back hundreds of results which doesnt help me at all. I'm not sure if I'm doing something wrong or not.
Upvote
0
Similar threads
