Avatar of Rayne
RayneFlag for United States of America asked on

dependent this

Hello,
There is a  source sheet that has the relationship between –
Region, country, state, county, city.

How do I do a dependent drop down from this data for the above?

Thank you
dependentThis.xlsx
Microsoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
Rayne

8/22/2022 - Mon
Naresh Patel

in your source there are many duplicated entries.

Thanks
Naresh Patel

you can do it by your self. follow this link Drop Down


Thanks
ASKER CERTIFIED SOLUTION
Naresh Patel

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
Rayne

Hello itJockey,

thank you for your help so far. I want it to read directly from raw data that has that relationship. Example of raw data is similar to here >>
http://www.contextures.com/xlSampleData01.html


Now how do i set it up - i am staying away from any manual creation as this report will be daily and needs to be refreshed for the 5 drop down metrics.

Also your data has only one city under any given condition - whereas in real world  - its one to many
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
Naresh Patel

you can achieve this process by just applying Filter.ScreendependentThis.xlsx
Naresh Patel

or I guess I dint understand what you want exactly.
Naresh Patel

let me know what you exactly want?
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Rob Henson

Also, by the way in the UK we do not have States; we only have counties. So straight away there is going to be a problem with you lists. Then again it could be a potential saving as you could combine the two lists into one, "State/County".

Thanks
Rob H
Rob Henson

See below for a couple of examples of the equivalent structure in the UK.

Where I am currently sat:
Region:    Europe
Country:  UK (or would it be England; as opposed to Wales, Scotland or Northern Ireland)
County:   Somerset
District:  South Somerset
Town:     Yeovil

Where I live:
Region:    Europe
Country:  UK
County:   Somerset
District:  Sedgemoor
Town:     Bridgwater

Thanks
Rob H
ASKER
Rayne

Thank you All, I will follow up later :)
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy