PC Review


Reply
Thread Tools Rate Thread

Advance Filter with Multi Criteria

 
 
chandra sekaran
Guest
Posts: n/a
 
      21st Jul 2010
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,




 
Reply With Quote
 
 
 
 
ryguy7272
Guest
Posts: n/a
 
      21st Jul 2010
On Jul 21, 6:54*am, chandra sekaran <duraichan...@gmail.com> 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 With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
.Filter for multi criteria based filteration. Faraz A. Qureshi Microsoft Access 3 16th Feb 2010 11:56 AM
Multi criteria selection / filter Schmidtnikov Microsoft Access Queries 1 22nd Oct 2009 03:51 PM
VBA Advanced Filter - latest lines for multi criteria Angus Microsoft Excel Programming 6 20th May 2009 02:58 AM
multi criteria filter Deus DNE Microsoft Excel Discussion 1 2nd Apr 2008 05:23 PM
Advance Filter Criteria =?Utf-8?B?Sm9yZGFu?= Microsoft Excel Worksheet Functions 2 9th Jul 2005 07:14 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:17 AM.