I have a data which relates to particular vendor where the payment is made in single line , but we have to review the Invoice and give the break up(Manually) for each line and later the single line will be splitted on weighted average method based on the breakup, which makes a long time work is there any formula or Macro that would help me to do the job very easily
I have also attached sample file for your reference
Below is the example of the Issues, Solution is appreciated
Question
Vendor name AMT
chevron 5000
Glencore 3000
TCS 5000
G&F 40000
Answer
Vendor name AMT Breakup Weighted average Formula
chevron 5000 1000 1000 =C14/SUM($C$14:$C$17)*B14
2000 2000
1000 1000
1000 1000
Glencore 3000 1500 1500
1500 1500
TCS 5000 1500 326.09
1500 326.09
1000 2,17.91
1000 2,17.91
G&F 40000 2000 3636.64
2000 3636.36
Bookmarks