• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Filter list in the excel

M

md.ayyub

New Member
Hi,


I Have excel sheet containing 3 list like Country, State, District, Street.


I want to filter the columns based on the selection of previous cell


Example : If I select Country as India i should get state's related to India, similarly i should get district based on the selection of state i.e., is related to the state that i have selected and the same functionality to others list


Please help me with small example
 
If you are using AutoFilter, what you've described is exactly how XL will work. Once you filter Country for "India", you would only see state's that correspond to India. Additionally, if you're actually wanting to make dependent drop downs, you might check this out:

http://www.contextures.com/xldataval02.html
 
Md.ayyub


Firstly, Welcome to the Chandoo.org Forums


I think Luke has answered your question correctly.

To Apply Autofilter select any cell in the Table of Values and goto Data, Filter


However if you are referring to a validation list which is dependent on the previous validated value the best spot to look at how to achieve that is at the Contextures Blog.


http://www.contextures.com/xlDataVal02.html
 
You must log in or register to reply here.
Back
Top