Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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, |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Advance Filter with Multi Criteria
On Jul 21, 6:54*am, chandra sekaran wrote:
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA Advanced Filter - latest lines for multi criteria | Excel Programming | |||
Advance Filter | Excel Programming | |||
Advance Filter | Excel Discussion (Misc queries) | |||
Advance Filter Criteria | Excel Worksheet Functions | |||
Advance filter search does not filter an exact match | Excel Programming |