Distribution of amount using If Cond / any other function / by VBA

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

If any one can please guide me as how to distribute the amount in one row to
other rows. Here the other rows keep on changing. For eg :

A B C
Name Amount Allocation on Total Amount
A 10 12.5
B 20 25
C 10 12.5
Total 40 50
D 50 0

X 30 6
Y 20 4
Total 50 10
Z 10 0

Pls let me know if there is any logical program or formula wherein I will be
able to apply it for the whole data at a time. It should check the "name"
Column and allocate as per the formula. Kindly help.
 
If any one can please guide me as how to distribute the amount in one row to
other rows. Here the other rows keep on changing. For eg :

A B C
Name Amount Allocation on Total Amount
A 10 12.5
B 20 25
C 10 12.5
Total 40 50
D 50 0

X 30 6
Y 20 4
Total 50 10
Z 10 0

Pls let me know if there is any logical program or formula wherein I will be
able to apply it for the whole data at a time. It should check the "name"
Column and allocate as per the formula. Kindly help.
Click to expand...


In C2 (row of "A"):
=B2*$D$2/$B$4

HTH
Kostis Vezerides
 
Back
Top