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
|