Hi,

I have two lists of shareholders that, depending on some assumptions, changes
Company A Company B
Shareholder Name Shareholder %. Shareholder Name Shareholder %.

Below I want to create a list that combines the two lists but ranks them
according to the new Shareholder %. Is there a way to create this (no VBA) so
that the ranked list will update depending on assumptions made earlier?