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

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
 

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

Two columns followed by single page-width column on same page 0
Special copying of columns 2
Excel 2002: How to get the first and last reference in a column ? 7
Add columns to reach a predetermined value 2
Excel for comparing two columns exceeding 1,048,576 count 3
Add a column based on criteria from 2 other columns 4
Looking forMacro to do this Sheet to Sheet copy &sort 0
Look for a value in two cells and match it with another 1

Top