Web in order to find the rank, i created a rankings table.

How to add a rank drop down list in excel. Web to add an item, go to the last row in the column, press enter or return, enter the new list item, and press enter or return again. This will open the code window for that. In the data validation dialog.

The formula i used to populate my rankings table is: Web looking to modify the following rank formula to automatically choose the correct column to rank based on a user picked drop down list. Web in the [include] field, add the following formula:

On the data tab, in the data tools group, click data validation. On the ribbon, click the data tab, and click data validation. Select the cells that you want to contain the lists.

In the dialog, set allow to list. Select the cells that you want to contain the lists. It shows the 2 ways you can do that in excel using formulas and vba.

In the text box labeled source, you can enter the options you want. Select the data tools group from the data tab. On the ribbon, click the data tab, and click data validation.