Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everyone,
I have a data of three products containing Qty, Sale Price & Value(As shown Below).
Product Name | Particular | UOM | Value |
A | Qty | MT | 100 |
B | Qty | MT | 150 |
C | Qty | MT | 200 |
A | Rate | Rs/MT | 800 |
B | Rate | Rs/MT | 900 |
C | Rate | Rs/MT | 600 |
A | Value | Rs/Lacs | 0.80 |
B | Value | Rs/Lacs | 1.35 |
C | Value | Rs/Lacs | 1.20 |
What i wanted to do is, i want a row generated automatically after every category of Particular column i.e. after qty, rate & Value respectively. Than on the inserted row i wanted to calculate sum & Weighted average, Sum for all the 3 products , Weighed average Rate for Rs/MT and sum of value. What i wanted is shown below in Red colour:
Product Name | Particular | UOM | Value |
A | Qty | MT | 100 |
B | Qty | MT | 150 |
C | Qty | MT | 200 |
Total | Qty | MT | 450 |
A | Rate | Rs/MT | 800.00 |
B | Rate | Rs/MT | 900.00 |
C | Rate | Rs/MT | 600.00 |
Total | Rate | Rs/MT | 744.44 |
A | Value | Rs/Lacs | 0.80 |
B | Value | Rs/Lacs | 1.35 |
C | Value | Rs/Lacs | 1.20 |
Total | Value | Rs/Lacs | 3.35 |
Please help me for completing the above task.
Thanks & Regards,
Ashish
Check This please
Neville
Thank you for the reply...... But i could not open the file. Will be grateful if you can give me the formula or Script written......
Thanks & Regards,
Ashish