Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comparing two columns some same some add up to others in column 2
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comparing two columns some same some add up to others in column 2
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? -- If this helps, please click the Yes button. Cheers, Shane Devenshire "navelkist" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
comparing 2 columns info to fill 3rd column | Excel Worksheet Functions | |||
comparing two columns | Excel Discussion (Misc queries) | |||
Comparing two columns of information with 2 new columns of informa | Excel Discussion (Misc queries) | |||
Comparing columns | Excel Discussion (Misc queries) | |||
Comparing Columns | Excel Worksheet Functions |