课程: Excel: Tracking Data Easily and Efficiently

今天就学习课程吧！

今天就开通帐号，24,600 门业界名师课程任您挑！

Challenge: Building a tracker 1

Challenge: Building a tracker 1 - Microsoft Excel教程

课程: Excel: Tracking Data Easily and Efficiently

开始一个月试用 购买团队方案

Challenge: Building a tracker 1

“

(upbeat music) - [Instructor] Here's your challenge. In cell B3, create a dynamic dropdown list with the following details. It includes all cities except those in Goodard County, it retrieves the city motto/nickname in cell D5, and displays the result in a shape. Let me show you the data. Over here, we have cities. Anvil Bluff, New Orange, Peanut Butter, and all the way over in column G, the city's mottoes and nicknames. That's what we want to retrieve, but like Cobalt, Dragon Banks, Drexel, they should not show up in our dropdown list, but we do want Ghost River because that's in Bowtie County. We want New Orange because that's in Cork, et cetera, et cetera. All right. Now, it's your turn. Create this dropdown list.

内容