ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Dynamic List (https://www.excelbanter.com/excel-worksheet-functions/150341-dynamic-list.html)

Kevin

Dynamic List
 
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?

bj

Dynamic List
 
the answer is probably yes, but can't help you more without an indication as
to the type of assumptions and how they change the percent column.
Note we don't need to know the details of what you do, but do need somthing
to go on.

"kevin" wrote:

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?



All times are GMT +1. The time now is 05:14 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com