VBA or Excel code to calculate the % of a unique value and how often it occurs

Hi All,

Please would you be able to assist me. Im a bit of an excel noob still but im trying to do a sports stock list for a local team i help manage and i would like to setup some VBA code or a formula.

What im trying to achieve is the following,

- Look through column "D" (ItemID) and sort into unique references
- Then count the total quantity using column "G" (Quantity) for each unique reference from column "D" (ItemID)
- Now using the above, make a new column which shows the percentage of the quantity against the total quantity for each unique reference.

TeamCode	TeamName	TeamArea	ItemID	Description	Group	Quantity	Percentage of stock
A12345	Team1	SE	0123	Footballs	SE1	5	25%
A12346	Team2	SE	0123	Footballs	SE1	5	25%
A12346	Team3	SE	0123	Footballs	SE1	10	50%
A12348	Team5	SE	0234	Tennis Balls	SE1	2	50%
A12359	Team8	SE	0234	Tennis Balls	SE1	2	50%
A12368	Team12	SE	586	Cricket Bats	SE1	10	25%
A12438	Team15	SE	586	Cricket Bats	SE1	30	75%
A15677	Team23	SE	9874	Golf Clubs	SE1	90	100%
A12178	Team25	SE	98654	Basketballs	SE1	23	100%

So as you can see above. Column "H" (Percentage of stock) shows the percentages of the quantity (Column "G") against the total quantity in reference to the unique reference in column "D" (ItemID).

Ive probably over complicated my explanation as well, so i hope it all makes sense and i appreciate your help.

Thank you.

Kind Regards
Z

Put this in H2 (assuming the header row is row 1) and drag down

=G2/SUMIF($D$2:$D$10,D2,$G$2:$G$10)

Rather than drag the outline for the D and G range down manually edit the first formula to D2:D1000 and the same for the G range then double click the formula to auto fill