Results 1 to 5 of 5
  1. #1
    Lounger
    Join Date
    Jan 2008
    Posts
    37
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Is there a way to find the cells that make up a total if they are not in one row/column? Basically we have an audited statement and we're trying to figure out how they came up with the total they did (it's not at all clear). There are a bunch of numbers and what I'd like to do is run a function that finds all the possible cells that can make up that specific total? Something like highlighting the entire sheet and then run the function to highlight all cells that can make up the total of xxxxx with each different scenario in different colors. If that even makes sense...

    Thanks.

  2. #2
    New Lounger
    Join Date
    May 2010
    Location
    Detroit, Michigan
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts
    With Excel 2007-2010 you can by conditional formatting the cells with colors and doing a sum function based on cell colors. On early versions use control+enter to choose non-continueous cells.

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    I am not sure what you want. Are you looking for dependencies of a formula?

    Steve

  4. #4
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts
    What you are asking is nearly impossible, especially with a large group of numbers.

    Consider, for example, the sum of 6 with possible addents of 1, 1, 2, 2, 3, 3. There are 10 different combinations possible.

    Code:
     
    1	1	2	2			6
    1		2		3		6
    1		2			3	6
    1			2	3		6
    1			2		3	6
    	1	2		3		6
    	1	2			3	6
    	1		2	3		6
    	1		2		3	6
    				3	3	6

  5. #5
    5 Star Lounger
    Join Date
    Dec 2009
    Location
    East Coast, USA
    Posts
    993
    Thanks
    8
    Thanked 43 Times in 43 Posts
    Click the cell that has the total. Then do the following ....
    Tools/Formula Auditing/Trace Precedents
    The line will place a dot in each cell that is used for the total.

Posting Permissions

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