Comparing two columns some same some add up to others in column 2

  • Thread starter Thread starter navelkist
  • Start date Start date
N

navelkist

Hi - I have two columns of transactions. Some in A equal exactly B, the rest
in A have to add up to one in B (combination of 2,3,4,...). Any suggestions
on an approach? Ex:

COLUMNA COLUMNB
1000 1000
250 1000
250
500
 
Hi,

There is no unique answer for this type of problem. You could use Solver to
return 1 solultion, but there is no guarantee that it will be the correct on.

Example,

You have 1 hundred entries half are $1 the other half $5. You have a number
5 in your other spreadsheet, which one is it? or is it =1+1+1+1+1 and if so
which 1's?
Or 6 = 5+1 but which 5 and which 1?
 

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

Index/match across multiple columns? 19
comparing two columns 2
Excel 2002: How to get the first and last reference in a column ? 7
How to locate which cells add up less than or equal to a certainnumber (where numbers can be repeate 1
Summing Contiguous Values in a Column? 6
Excel Comparing two columns 1
SUMIF WITH MULTIPLE CRITERIA 3
LOOKUP? 2

Back
Top