conditional drop down

[sunil.kini]

In the attached excel file there are list of names and list of cities. If I select city as "DELHI" for "A", I should not get "DELHI" in subsequent drop downs. Means next drop downs should show only remaining cities. Please help me on this.<!-- google_ad_section_end -->

 

[grizz]

the reason you only have 6 entries in your dropdown is the formula you have in your name range only goes to C6

 

[sunil.kini]

the reason you only have 6 entries in your dropdown is the formula you have in your name range only goes to C6

Please help me to modify the formulae.

 

[grizz]

I'm not sure exactly what your looking for but lets give it a shot
you have 500 cities and want a drop down if Delhi selected that will not show up in the next dropdown -- how many dropdowns will you have

 

[grizz]

your formula looks good you just need to extend the range but I would suggest altering your drop down if you have 500 names in it

 

[sunil.kini]

I'm not sure exactly what your looking for but lets give it a shot
you have 500 cities and want a drop down if Delhi selected that will not show up in the next dropdown -- how many dropdowns will you have

I have 500 cities in drop down and 500 employees in front of which 500 cities will be mapped.