Results 1 to 3 of 3

Thread: Auto-filling grid challenge

  1. #1

    Auto-filling grid challenge

    Register for a FREE account, and/
    or Log in to avoid these ads!

    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)

    A B C D
    1 500
    2 250
    3 350
    4 100 1000 200

    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"?


  2. #2
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Excel Version
    Row 4 doesn't equal column D!

  3. #3
    Quote Originally Posted by Bob Phillips View Post
    Row 4 doesn't equal column D!
    Fair enough.

    Now it does.
    Is there a way to solve?

    A B C D
    1 500
    2 250
    3 350
    4 100 800 200

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts