Create a string or list based on the values of other strings, such as dropdown in cells containing Arab countries, dropdown with other cells containing those cities. Countries are specified so that cities change when changing country, and this is done only by (indirect function). in excel

COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
1st Edition
ISBN:9780357392676
Author:FREUND, Steven
Publisher:FREUND, Steven
Chapter11: User Interfaces, Visual Basic For Applications (vba), And Collaboration Features
Section: Chapter Questions
Problem 3EYW
icon
Related questions
Question

Create a string or list based on the values of other strings, such as dropdown in cells containing Arab countries, dropdown with other cells containing those cities.

Countries are specified so that cities change when changing country, and this is done only by (indirect function). in excel

Expert Solution
steps

Step by step

Solved in 4 steps with 10 images

Blurred answer
Knowledge Booster
Lists
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:
9780357392676
Author:
FREUND, Steven
Publisher:
CENGAGE L