+ Reply to Thread
Results 1 to 2 of 2

Goal seek to see if I can reconcile a number

  1. #1
    Registered User
    Join Date
    02-15-2017
    Location
    South Carolina
    MS-Off Ver
    Current
    Posts
    1

    Goal seek to see if I can reconcile a number

    Okay here is what I am trying to do. I have a balance that I am trying to reconcile from about 300 cells of data. Is there a way to do a goal seek type of thing where I can say (in excel) essentially "out of this list of data, can you add any of them together the totals up this number". As a basic example (incase you aren't following) say from A1:A30 I have random numbers. In B1 I have the amount $1,234. Is there a way to tell excel: "By adding 3 of these numbers, can you find the amount in B1". Does make sense? I would add the excel information, but it is sensitive information. If anyone knows any way for me to do this, I would be so thankful.

    Thank you SO much!

    -Clay

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Goal seek to see if I can reconcile a number

    Welcome to the board.

    See http://www.excelforum.com/excel-form...l-to-cell.html
    Entia non sunt multiplicanda sine necessitate

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] getting to a number using goal seek, maybe
    By ammartino44 in forum Excel General
    Replies: 4
    Last Post: 09-21-2015, 07:08 PM
  2. [SOLVED] Seeking Goal without using Goal Seek
    By Doc Science in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-07-2015, 02:24 PM
  3. Replies: 3
    Last Post: 07-27-2012, 01:44 PM
  4. Goal Seek VBA with relative 'Goal' parameter
    By alirulez in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-07-2012, 07:19 PM
  5. Goal Seek Formula But Not Using Goal Seek
    By cady923 in forum Excel General
    Replies: 1
    Last Post: 08-05-2011, 03:53 PM
  6. Goal Seek
    By Mike in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-23-2006, 12:45 AM
  7. Goal Seek
    By scious in forum Excel General
    Replies: 3
    Last Post: 01-31-2005, 02:39 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1