Hi,
I am struggling a bit with the following issue:
Say there are 6 shareholders in 1 company, each with their respective ownership and voting rights.
Now I want to list all scenarios whereby there are at least 4 shareholders in favor of a vote, and that the combined ownership of the shareholders in favor is at least 50%.
How can that be done? Can this be done using VBA?
Example:
Shareholder 1 30 %
Shareholder 2 30 %
Shareholder 3 15 %
Shareholder 4 13 %
Shareholder 5 10 %
Shareholder 6 2 %
In this case, if Shareholder 1, 2, 3 and 4 are in favor, there are 4 shareholders in favor, and the combined ownership is 88%, so both criteria are fulfilled.
However, if Shareholder 2, 3, 4, 5 and 6 are in favor, both criteria are also fulfilled (5 shareholders in favor and total ownership is 70%).
Bookmarks