Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Help please...
I have a single column of data that is over 256 rows. They are dollar amounts and I am looking for every possible combination of the numbers that equal a specific dollar amount. It could be that is only a sum of two numbers or it could be three, four or five or more, however, 95% of the time it is only the sum of two numbers. I haven't been able to figure out from the help feature how to solve this problem. I was manually doing it by copying the data and transposing it but this only works when I have less than 255 rows. A simple example of my problem would be this... My data: 1 2 3 4 7 and I am looking for every possible combination that gives me 9. Easy to do in my head but I can't when I have so many rows. Anyone able to guide me on this? Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Populate an array that is a subset of a larger array? | Excel Worksheet Functions | |||
Array: Counting multiple values within array | Excel Worksheet Functions | |||
meaning of : IF(Switch; Average(array A, array B); array A) | Excel Worksheet Functions | |||
combining cells and array from different sheets into an array to pass to IRR() | Excel Discussion (Misc queries) | |||
Goal Seek On Members of an Array within Array | Excel Worksheet Functions |