Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi
I need help in solving for an issue in excel. A macro is required. We have a list of 700 numbers and we need to find out how many combinations match a particular number, if we add numbers from the list of 700. Example: List of numbers: 1234 63 8903 3446 8112 854 .... and so on Target: 8966 Solution: Option 1: 8112+854 Option 2: 63+8903 Is this possible in excel macro. I found one here, but this is not useful for more than 4 numbers. http://en.allexperts.com/q/Excel-105...s-x-number.htm I would appreciate it if a solution to this is available on excel or any other software. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Combination of given numbers | Excel Discussion (Misc queries) | |||
Combination of formulas, if, and, or | Excel Worksheet Functions | |||
combination | Excel Discussion (Misc queries) | |||
Combination | Charts and Charting in Excel | |||
Combination bar Charts | Charts and Charting in Excel |