Adding multiple items in unordered data to match a target amount

I have 3 columns of data - invoiced amounts (A), banked amounts (B) and 
commission charged (C).  A = B + C

For each B, there is one C.  
However, there can be multiple items in A for one item of B + C.
Further, the rules for how commission is charged varies by amounts sold; I 
cannot calculate C by reference to A or B (individually) with any level of 

I'm therefore looking for a way of selecting 1 or multiple items in column 
B, adding them to 1 or multiple items in column C and tracing this to 1 or 
multiple items in column A.

Help would be gratefully received.
4/16/2010 2:12:01 PM
excel.misc 78881 articles. 5 followers. Follow

0 Replies

Similar Articles

[PageSpeed] 42


Similar Artilces: