Specifically, in cell H2, you want to create a drop-down list of all the nations listed in column B, and in cells I2 and J2, display the player names and average score, respectively, according to ...

Here's how to create a drop-down list in Microsoft Excel. Skip ... Go to the Data tab and select the Data validation button or choose Data validation from the ... Both options sport their own design.

If design mode is not automatically enabled, click the icon to enable it -- it looks like a finger cursor pointing to the word "OK," and is the second button on the toolbar. Click the Combo Box ...