Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a column with totals in it (numbers). From this array of numbers I
want to search for any combination by (adding these numbers together) that will equal a number in another cell say B3. Another way to say this is: in Column A I have in each row a number. In cell B3 I have the number I am looking for, which could be any combination of adding the numbers from Column A. Is their a way I can search column A and come up with a combination that will equal what I am searching for in Cell B3? Column A Column B 1 2 3 26 4 5 6 7 8 9 .... -- Thanks, Kate |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
search array | Excel Worksheet Functions | |||
Defining an array to search by | Excel Discussion (Misc queries) | |||
Text Search in an Array | Excel Worksheet Functions | |||
Text Search in an Array | Excel Discussion (Misc queries) | |||
Search array and return element No | Excel Worksheet Functions |