A | B | C | D | |
1 | 500 | |||
2 | 250 | |||
3 | 350 | |||
4 | 100 | 800 | 200 |
I am sure the answer has already been posted, but I am afraid I do not even know how to search for it - cause i am calling it the wrong thing.
I am an excel novice (I would put me at a 4.5 out of 10)
I want excel to auto fill in the blanks (A-C, 1-3) for me. Column D and Row 4 are totals for each row/column.
Obviously - I know Row 4 needs to equal Column D.
But is there a solver that can find the numbers that satisfy both sums?
can someone suggest a link or tutorial? Or even the right way to identify this "opportunity"?
Can Excel even do this calculation? Should I be using another program? The end result has to be Excel compatible in order for my output to generate properly.
Thanks