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

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.

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

On Jun 1, 3:17 pm, Surya Vyas <Surya
wrote:
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.


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

HTH
Kostis Vezerides