Advance Filter with Multi Criteria

C

chandra sekaran

Region State Capital Languages
_____________________________________________
Central India Bihar Patna Hindi
Central India Chandigarh Chandigarh Hindi
Central India Chattisgarh Raipur Hindi
Central India Jharkhand Ranchi Hindi
Central India Madhya Pradesh Bhopal Hindi
Central India Rajasthan Jaipur Rajasthani
Central India Uttarakhand Dehradun Hindi
East India Assam Dispur Assamese
East India Haryana Chandigarh Hindi
East India Himachal Pradesh Shimla Pahari
East India Maharashtra Mumbai Marathi
East India Manipur Imphal Manipuri
East India Meghalaya Shillong Khasi, Jaintia and Garo
East India Mizoram Aizawl Mizo and English
East India Nagaland Kohima Ao, Konyak, Angami, Sema and Lotha
East India Orissa Bhubaneswar Oriya
East India Punjab Chandigarh Punjabi
East India Sikkim Gangtok Bhutia, Hindi, Nepali, Lepcha, Limbu
East India Tripura Agartala Bengali, Tripuri, Manipuri, Kakborak
EAST INDIA West Bengal Kolkata Bengali
North India Arunachal Pradesh Itanagar Miji, Apotanji, Merdukpen,
Tagin,Adi, Honpa, Bangini-Nishi.
North India Delhi Delhi Hindi
North India Jammu and Kashmir Srinagar Hindi
North India Uttar Pradesh Lucknow Hindi
south India Andaman and Nicobar Islands Port Blair Hindi
south India Andhra Pradesh Hyderabad Hindi
south India Karnataka Bengaluru Kannda
south India Kerala Thiruvananthapuram Malayalam
south India Lakshadweep Kavaratti Tamil
south India Puducherry Puducherry Tamil
south India Tamil Nadu Chennai Tamil
west India Dadra and Nagar Haveli Silvassa Tamil
west India Daman and Diu Daman Marathi and Konkani
west India Goa Panaji Marathi and Konkani
west India Gujarat Gandhinagar Gujarati

'------------------------------------------------------------------------------------------------------
Critria list

Region :..........................
State :..........................
Capital :..........................
Languages :..........................
------------------------------------------------------------------------

Criteria List should come Option list box

Based on above Criteria list how can do the Advanced Filter you

Please Help me sir,
 
R

ryguy7272

Region  State   Capital Languages
_____________________________________________
Central India   Bihar   Patna   Hindi
Central India   Chandigarh      Chandigarh      Hindi
Central India   Chattisgarh     Raipur  Hindi
Central India   Jharkhand       Ranchi  Hindi
Central India   Madhya Pradesh  Bhopal  Hindi
Central India   Rajasthan       Jaipur  Rajasthani
Central India   Uttarakhand     Dehradun        Hindi
East India      Assam   Dispur  Assamese
East India      Haryana Chandigarh      Hindi
East India      Himachal Pradesh        Shimla  Pahari
East India      Maharashtra     Mumbai  Marathi
East India      Manipur Imphal  Manipuri
East India      Meghalaya       Shillong        Khasi, Jaintia and Garo
East India      Mizoram Aizawl  Mizo and English
East India      Nagaland        Kohima  Ao, Konyak, Angami, Sema and Lotha
East India      Orissa  Bhubaneswar     Oriya
East India      Punjab  Chandigarh      Punjabi
East India      Sikkim  Gangtok Bhutia, Hindi, Nepali, Lepcha, Limbu
East India      Tripura Agartala        Bengali, Tripuri, Manipuri, Kakborak
EAST INDIA      West Bengal     Kolkata Bengali
North India     Arunachal Pradesh       Itanagar        Miji, Apotanji, Merdukpen,
Tagin,Adi, Honpa, Bangini-Nishi.
North India     Delhi   Delhi   Hindi
North India     Jammu and Kashmir       Srinagar        Hindi
North India     Uttar Pradesh   Lucknow Hindi
south India     Andaman and Nicobar Islands     Port Blair      Hindi
south India     Andhra Pradesh  Hyderabad       Hindi
south India     Karnataka       Bengaluru       Kannda
south India     Kerala  Thiruvananthapuram      Malayalam
south India     Lakshadweep     Kavaratti       Tamil
south India     Puducherry      Puducherry      Tamil
south India     Tamil Nadu      Chennai Tamil
west India      Dadra and Nagar Haveli  Silvassa        Tamil
west India      Daman and Diu   Daman   Marathi and Konkani
west India      Goa     Panaji  Marathi and Konkani
west India      Gujarat Gandhinagar     Gujarati

'--------------------------------------------------------------------------­----------------------------
Critria list

Region  :..........................
State   :..........................
Capital :..........................
Languages       :..........................
------------------------------------------------------------------------

Criteria  List  should come  Option list box

Based on above  Criteria  list   how can  do the Advanced Filter  you

Please Help me  sir,

Take a look at Dependent Lists.
http://www.contextures.com/xlDataVal02.html

I think that will do what you want.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top