|Posted by:||navin (navin.naraya…@gmail.com)|
|Date:||12 Jan 2007|
I have a sheets, in which Col A has supplier names, Col B has part
supplied by the supplier and Col C has qty supplied.
Supplier Part qty
AAAAA XXXX 2222
AAAAA 1111 232
AAAAA wwas 334
BBBBB ****** 345
BBBBB ++++ 675
BBBBB #### 7876
Now i want to calculate the total qty for one supplier and then in
another col get the ratio of a qty for part by the total number of qty
for that supplier. With the above example:
it should calculate, first the total# of qty for Supp: AAAAA and then
each part qty for supplier AAAAA has to be divided by the total number
of qty for Supplier: AAAAA.
I know this sounds confusing, but this is i want.