| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
find numbers in a range that add to a specific value
Jason previously answered the above question with the below answer however I
am looking for a formula that works when adding more than 2 numbers together? Can anyone help? thanks, Brett Assuming your list of numbers are in A1:A50 and the total number is in F1, try this in B1 and copy down to B50: =ADDRESS(SUMPRODUCT(--(A1+$A$1:$A$50=$F$1),ROW(INDIRECT("1:50"))),1,4) If there are any feasible combinations, a cell reference will appear next to a number. That number, but the number in the cell reference, will equal the number in F1. HTH Jason Atlanta, GA |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
| Sorting imported "numbers" | Excel Discussion (Misc queries) | |||
| To find a combination of numbers that equal a set amount? | Excel Discussion (Misc queries) | |||
| How do you find duplicate values in excel- 2 columns of numbers | Excel Discussion (Misc queries) | |||
| two columns of numbers, need to sort/filter to find one number th. | Excel Discussion (Misc queries) | |||
Threaded Mode
