Sample Data attached.
I have data as above. A,B,C is available. D is based on B and C. Requirement is defined in "E" column.
If a product is repeated the average rate is sum of multiplication of rate and value divided by sum of values. Although, the formula is explained in "E" Column but this is small data. I have over a million values in "A" out of which some(not all) are repeated(twice or thrice). Applying formula to each of them is difficult. Kindly suggest a shortcut.
Bookmarks