Hello,
I have a list of stock prices and a list of the number of shares.
Both totalling 50.
I want to create something that will list all of the weights based upon (share x price) / (Sum of Price x share) standard weighting formula.
However i want to have a function that allows me to cross off certain stocks so that it reweights for the remaining number of companies there.
So if for example i crossed off two companies all the weightings would reweight for the last 48 stocks.

Hope this makes sense.

shares are in B weightings are in D