Find Numbers in a range that to a specific number

  • Thread starter Thread starter GregR
  • Start date Start date
G

GregR

Is there a way to find 2 numbers in a list that would add up to a specific
number. Needed for bank reconciliation. The numbers can be anywhere from 5
to 500
in the list, there are some negative numbers and I only want one
combination. TIA

Greg
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Reconciling Numbers 2
What combination of numbers in a series sums to a specific value? 2
sum last 3 numbers greater that 0 in a range 0
Sorting a list of numbers 4
How to locate which cells add up less than or equal to a certainnumber (where numbers can be repeate 1
Adding only negative numbers in row 3
Addition function of multiple cells 10
3D array SUMIF 2

Back
Top