View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
chandra sekaran chandra sekaran is offline
external usenet poster
 
Posts: 11
Default Advance Filter with Multi Criteria

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,