millylopez04
New Member
- Joined
- Jul 12, 2019
- Messages
- 3
Hello!
I'm trying to find what possible combination of numbers is causing a variance. I saw someone do a formula once to find this but I don't have that formula. We have a statement with close to 500 lines and I wanted to be able to find which combination of those number would make $$$ amount that I'm off.
I just tried a method I found online using solve add-in and it's been over 30 mins and excel is still working on that. It's basically frozen, so far it says it's on the 20,000+ subproblem and counting up fast, but I haven't seen any solution yet. When I saw this person do a formula before it didn't take long at all, so I'm wondering if there's a different way.
Any help is appreciated, thanks in advance!
Milly
I'm trying to find what possible combination of numbers is causing a variance. I saw someone do a formula once to find this but I don't have that formula. We have a statement with close to 500 lines and I wanted to be able to find which combination of those number would make $$$ amount that I'm off.
I just tried a method I found online using solve add-in and it's been over 30 mins and excel is still working on that. It's basically frozen, so far it says it's on the 20,000+ subproblem and counting up fast, but I haven't seen any solution yet. When I saw this person do a formula before it didn't take long at all, so I'm wondering if there's a different way.
Any help is appreciated, thanks in advance!
Milly