Drop down lists

Resolved · Medium Priority · Version 2016

Wed 30 Aug 2017, 17:02 Delegate Clélia-elsa said...

Clélia-elsa has attended:
Excel Advanced course

Drop down lists

how to create a second drop down list that update based on the value of the first one.
eg. if I have two columns, one with countries and one with cities, if I select USA in the first drop down column, then I only see in my second drop down the cities in the USA

Wed 30 Aug 2017, 21:39 Edited on Wed 30 Aug 2017, 21:48 Trainer Jens said...

RE: drop down lists

Hi Clélia-elsa,

Thank you for the forum question.

Please find attached file.

If you click in column A you can select a country. This will control the cities you can select in column B. I am using dynamic ranges so I can add more countries and cities without updating the rules. Select column B inside the dynamic range and click datavalidation, you can see how I reference the dynamic ranges in the Indirect function.

I hope my example make sense

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Attached files...

datavalidation.xlsx

Wed 6 Sep 2017: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Using basic functions without doing formulas

When you highlight figures Autocalc tells you the total in the bottom right of the screen, but if you right click on the sum it will give you some basic functions. The functions are Min, Max, Average, Sum, Count, and Count Nums.

View all Excel hints and tips