Hello you can use VLookup formula for this Problem of abbreviations Go to Tools - Functions and type in the dialogue box vlookup Regards CA MOHIT GUPTA +91-9415055308
On Sat, Sep 22, 2012 at 12:30 AM, <accessindia-requ...@accessindia.org.in>wrote: > Send AccessIndia mailing list submissions to > accessindia@accessindia.org.in > > To subscribe or unsubscribe via the World Wide Web, visit > > http://mail.accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in > > or, via email, send a message with subject or body 'help' to > accessindia-requ...@accessindia.org.in > > You can reach the person managing the list at > accessindia-ow...@accessindia.org.in > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of AccessIndia digest..." > > > Please do not reply to this digest mail. You should put your comments into > a new mail with appropriate subject line. > _______________________________________________ > AccessIndia mailing list > AccessIndia@accessindia.org.in > > http://mail.accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in > > > Today's Topics: > > 1. Re: Problem to open downloaded file (Aashutosh pandey) > 2. Re: Excel formula (Mukesh) > 3. Re: Excel formula (Aashutosh pandey) > 4. Re: how to restrict youtube from opening (Shona Man) > 5. Re: how to restrict youtube from opening (Shona Man) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Fri, 21 Sep 2012 21:11:09 +0530 > From: Aashutosh pandey <cuteaashutos...@gmail.com> > To: accessindia@accessindia.org.in > Subject: Re: [AI] Problem to open downloaded file > Message-ID: > <CABufMjOk_MhmtJj==h=x9J6HGaoocJby0PaDw8mDE= > nn2lb...@mail.gmail.com> > Content-Type: text/plain; charset=ISO-8859-1 > > Dear sir i use internet explorer i don't use any download manager i > searched in c:/downloads or c:,d:,e: but i couldn't get in the morning > i'm able to download in mydocument/downloads but suddenly in afternoon > i'm unable to do like this or is there any other option . > mob:08933845544 > Skype:aashutoshpandey1 > > On 9/21/12, uphar.73 <uphar...@gmail.com> wrote: > > Search in c :/downloads.Here you will get your needs. > > ----- Original Message ----- > > From: "Aashutosh pandey" <cuteaashutos...@gmail.com> > > To: <accessindia@accessindia.org.in> > > Sent: Friday, September 21, 2012 4:53 PM > > Subject: [AI] Problem to open downloaded file > > > > > >> Hello to all today i downloaded a file but when i was searching in > >> downloads in mydocument i couldn't get that when it was downloading it > >> was sowing that it is downloading in temporaryfolder but i don't know > >> where is temporary folder please help me as soon as you can > >> mob:08933845544 > >> Skype:aashutoshpandey1 > >> > >> -- > >> Thanks with best regards > >> Aashutosh Pandey > >> > >> > >> Search for old postings at: > >> http://www.mail-archive.com/accessindia@accessindia.org.in/ > >> > >> To unsubscribe send a message to > >> accessindia-requ...@accessindia.org.in > >> with the subject unsubscribe. > >> > >> To change your subscription to digest mode or make any other changes, > >> please visit the list home page at > >> > http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in > >> > > > > > > > > Search for old postings at: > > http://www.mail-archive.com/accessindia@accessindia.org.in/ > > > > To unsubscribe send a message to > > accessindia-requ...@accessindia.org.in > > with the subject unsubscribe. > > > > To change your subscription to digest mode or make any other changes, > please > > visit the list home page at > > > http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in > > > > > > > -- > Thanks with best regards > Aashutosh Pandey > > > > ------------------------------ > > Message: 2 > Date: Fri, 21 Sep 2012 21:59:13 +0530 > From: "Mukesh" <mukeshbaviskar....@gmail.com> > To: <accessindia@accessindia.org.in> > Subject: Re: [AI] Excel formula > Message-ID: <C9B9433720904697A28A5D31BE6D067F@MukeshPC> > Content-Type: text/plain; format=flowed; charset="iso-8859-1"; > reply-type=original > > Hello Ashutosh, > Thank you. It is working fine. Now I have one more query: > cell a1 cell b1 > any name of district abbreviation of district > (for example: Nashik: nsk, Pune: pu, Latur: l, etc) > My question is: > When I type a name of any district in cell a1 the abbreviation of that > particular district should come in cell b1 automatically. Suppose I type > 'Nashik' in cell a1 the abbreviation of Nashik should automatically come in > cell b1 'nsk'. Please guide me at the earliest because I have to complete > my > database within two/three days. Thank you. > > Regards > > Mukesh Baviskar > Mobile: 9403161157 > > -------------------------------------------------- > From: "Aashutosh pandey" <cuteaashutos...@gmail.com> > Sent: Friday, September 21, 2012 2:59 PM > To: <accessindia@accessindia.org.in> > Subject: Re: [AI] Excel formula > > > Sir you can use =concatinet() hopeit will work > > > > On 9/20/12, Mukesh <mukeshbaviskar....@gmail.com> wrote: > >> Dear Friends, > >> I have created a database in excel. My query is: > >> Columns: a1 b1 c1 d1 > >> Titles: districts vi/si m/F (Combination abbreviation of these three > >> cells > >> should come automatically) > >> Example: Nashik vi m nskmvi > >> How to do this with a formula? Please suggest me a formula at the > >> earliest. > >> Thank you. > >> Regards > >> Mukesh Baviskar > >> Mobile: 9403161157 > >> > >> Search for old postings at: > >> http://www.mail-archive.com/accessindia@accessindia.org.in/ > >> > >> To unsubscribe send a message to > >> accessindia-requ...@accessindia.org.in > >> with the subject unsubscribe. > >> > >> To change your subscription to digest mode or make any other changes, > >> please > >> visit the list home page at > >> > http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in > >> > >> > > > > > > -- > > Thanks with best regards > > Aashutosh Pandey > > > > > > Search for old postings at: > > http://www.mail-archive.com/accessindia@accessindia.org.in/ > > > > To unsubscribe send a message to > > accessindia-requ...@accessindia.org.in > > with the subject unsubscribe. > > > > To change your subscription to digest mode or make any other changes, > > please visit the list home page at > > > http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in > > > > > > ------------------------------ > > Message: 3 > Date: Fri, 21 Sep 2012 23:20:49 +0530 > From: Aashutosh pandey <cuteaashutos...@gmail.com> > To: accessindia@accessindia.org.in > Subject: Re: [AI] Excel formula > Message-ID: > <CABufMjPZn47EZ4C5b= > vbb370gw7-ydancynvh9ze-btsqbm...@mail.gmail.com> > Content-Type: text/plain; charset=ISO-8859-1 > > I'm very sorry sir i can't help you further because i don't have idia > about it but you should send this mail on our mailing list again hear > are many expert who will help us please sorry > mob:08933845544 > Skype:aashutoshpandey1 > > On 9/21/12, Mukesh <mukeshbaviskar....@gmail.com> wrote: > > Hello Ashutosh, > > Thank you. It is working fine. Now I have one more query: > > cell a1 cell b1 > > any name of district abbreviation of district > > (for example: Nashik: nsk, Pune: pu, Latur: l, etc) > > My question is: > > When I type a name of any district in cell a1 the abbreviation of that > > particular district should come in cell b1 automatically. Suppose I type > > 'Nashik' in cell a1 the abbreviation of Nashik should automatically come > in > > > > cell b1 'nsk'. Please guide me at the earliest because I have to > complete my > > > > database within two/three days. Thank you. > > > > Regards > > > > Mukesh Baviskar > > Mobile: 9403161157 > > > > -------------------------------------------------- > > From: "Aashutosh pandey" <cuteaashutos...@gmail.com> > > Sent: Friday, September 21, 2012 2:59 PM > > To: <accessindia@accessindia.org.in> > > Subject: Re: [AI] Excel formula > > > >> Sir you can use =concatinet() hopeit will work > >> > >> On 9/20/12, Mukesh <mukeshbaviskar....@gmail.com> wrote: > >>> Dear Friends, > >>> I have created a database in excel. My query is: > >>> Columns: a1 b1 c1 d1 > >>> Titles: districts vi/si m/F (Combination abbreviation of these three > >>> cells > >>> should come automatically) > >>> Example: Nashik vi m nskmvi > >>> How to do this with a formula? Please suggest me a formula at the > >>> earliest. > >>> Thank you. > >>> Regards > >>> Mukesh Baviskar > >>> Mobile: 9403161157 > >>> > >>> Search for old postings at: > >>> http://www.mail-archive.com/accessindia@accessindia.org.in/ > >>> > >>> To unsubscribe send a message to > >>> accessindia-requ...@accessindia.org.in > >>> with the subject unsubscribe. > >>> > >>> To change your subscription to digest mode or make any other changes, > >>> please > >>> visit the list home page at > >>> > http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in > >>> > >>> > >> > >> > >> -- > >> Thanks with best regards > >> Aashutosh Pandey > >> > >> > >> Search for old postings at: > >> http://www.mail-archive.com/accessindia@accessindia.org.in/ > >> > >> To unsubscribe send a message to > >> accessindia-requ...@accessindia.org.in > >> with the subject unsubscribe. > >> > >> To change your subscription to digest mode or make any other changes, > >> please visit the list home page at > >> > http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in > >> > > > > > > Search for old postings at: > > http://www.mail-archive.com/accessindia@accessindia.org.in/ > > > > To unsubscribe send a message to > > accessindia-requ...@accessindia.org.in > > with the subject unsubscribe. > > > > To change your subscription to digest mode or make any other changes, > please > > visit the list home page at > > > http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in > > > > > > > -- > Thanks with best regards > Aashutosh Pandey > > > > ------------------------------ > > Message: 4 > Date: Sat, 22 Sep 2012 00:01:38 +0530 > From: Shona Man <shonam...@gmail.com> > To: accessindia@accessindia.org.in > Subject: Re: [AI] how to restrict youtube from opening > Message-ID: > < > caf2k8deknd7lj_ydkvgsuazianadgyopom+ampwlcpwad+y...@mail.gmail.com> > Content-Type: text/plain; charset=ISO-8859-1 > > yes this is working, thanx > > On 9/21/12, Sheik mohammedali <shahid.se...@gmail.com> wrote: > > O sorry. > > folow these steps exactly: > > go to internet options and go to content tab and hit enter on enable... > > button and then press control+tab until you get approved sites tab and > type > > > > the website which you want to block and press tab until you get never > > button. once you activate "never allow button", you will be asked to set > > supervisor's password. then follow the instructions on screen. > > ----- Original Message ----- > > From: "Shona Man" <shonam...@gmail.com> > > To: <accessindia@accessindia.org.in> > > Sent: Friday, September 21, 2012 4:39 PM > > Subject: Re: [AI] how to restrict youtube from opening > > > > > >> Hi this method is not working as privacy setting is only about > >> blocking kukies and not about the blocking the website from opening. > >> suggest other method please. > >> > >> On 9/21/12, Sheik mohammedali <shahid.se...@gmail.com> wrote: > >>> hello, I don't recommend these browsers settings to restrict the sites. > >>> there are some parent utilities which can restrict the contents. write > >>> to > >>> me personally if you need further assistance. > >>> ----- Original Message ----- > >>> From: "Phen Varghese" <phenvargh...@gmail.com> > >>> To: <accessindia@accessindia.org.in> > >>> Sent: Friday, September 21, 2012 10:22 AM > >>> Subject: Re: [AI] how to restrict youtube from opening > >>> > >>> > >>>> Hi, > >>>> > >>>> Well that is a good info. > >>>> Well i have a question. > >>>> What is the method to unblock the site? > >>>> > >>>> RGDS, > >>>> > >>>> Phen Varghese > >>>> > >>>> On 9/21/12, Sheik mohammedali <shahid.se...@gmail.com> wrote: > >>>>> internet explorer: > >>>>> go to internet options usually under control pannel or type > >>>>> inetcpl.cpl > >>>>> under run. > >>>>> then, pres control+tab until you get privacy page. then, press tab > >>>>> until > >>>>> you get sites... and type the site which you want to block and press > >>>>> tab > >>>>> until you get block. > >>>>> ----- Original Message ----- > >>>>> From: "Shona Man" <shonam...@gmail.com> > >>>>> To: "accessindia" <accessindia@accessindia.org.in> > >>>>> Sent: Thursday, September 20, 2012 11:05 PM > >>>>> Subject: [AI] how to restrict youtube from opening > >>>>> > >>>>> > >>>>>> Hid friends I am using internet explorer 8 and mozilla 15, I want > >>>>>> that > >>>>>> nobody could open youtube from my system because it waste my time. > So > >>>>>> friends please guide me how can i restrict youtube from opening in > >>>>>> these browsers. > >>>>>> > >>>>>> -- > >>>>>> LL.M candidate > >>>>>> at Faculty of Law in University of Delhi > >>>>>> > >>>>>> > >>>>>> Search for old postings at: > >>>>>> http://www.mail-archive.com/accessindia@accessindia.org.in/ > >>>>>> > >>>>>> To unsubscribe send a message to > >>>>>> accessindia-requ...@accessindia.org.in > >>>>>> with the subject unsubscribe. > >>>>>> > >>>>>> To change your subscription to digest mode or make any other > changes, > >>>>>> please visit the list home page at > >>>>>> > http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in > >>>>>> > >>>>> > >>>>> > >>>>> > >>>>> Search for old postings at: > >>>>> http://www.mail-archive.com/accessindia@accessindia.org.in/ > >>>>> > >>>>> To unsubscribe send a message to > >>>>> accessindia-requ...@accessindia.org.in > >>>>> with the subject unsubscribe. > >>>>> > >>>>> To change your subscription to digest mode or make any other changes, > >>>>> please > >>>>> visit the list home page at > >>>>> > http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in > >>>>> > >>>>> > >>>> > >>>> > >>>> Search for old postings at: > >>>> http://www.mail-archive.com/accessindia@accessindia.org.in/ > >>>> > >>>> To unsubscribe send a message to > >>>> accessindia-requ...@accessindia.org.in > >>>> with the subject unsubscribe. > >>>> > >>>> To change your subscription to digest mode or make any other changes, > >>>> please visit the list home page at > >>>> > http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in > >>>> > >>> > >>> > >>> > >>> Search for old postings at: > >>> http://www.mail-archive.com/accessindia@accessindia.org.in/ > >>> > >>> To unsubscribe send a message to > >>> accessindia-requ...@accessindia.org.in > >>> with the subject unsubscribe. > >>> > >>> To change your subscription to digest mode or make any other changes, > >>> please > >>> visit the list home page at > >>> > http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in > >>> > >>> > >> > >> > >> -- > >> LL.M candidate > >> at Faculty of Law in University of Delhi > >> > >> > >> Search for old postings at: > >> http://www.mail-archive.com/accessindia@accessindia.org.in/ > >> > >> To unsubscribe send a message to > >> accessindia-requ...@accessindia.org.in > >> with the subject unsubscribe. > >> > >> To change your subscription to digest mode or make any other changes, > >> please visit the list home page at > >> > http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in > >> > > > > > > > > Search for old postings at: > > http://www.mail-archive.com/accessindia@accessindia.org.in/ > > > > To unsubscribe send a message to > > accessindia-requ...@accessindia.org.in > > with the subject unsubscribe. > > > > To change your subscription to digest mode or make any other changes, > please > > visit the list home page at > > > http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in > > > > > > > -- > LL.M candidate > at Faculty of Law in University of Delhi > > > > ------------------------------ > > Message: 5 > Date: Sat, 22 Sep 2012 00:15:41 +0530 > From: Shona Man <shonam...@gmail.com> > To: accessindia@accessindia.org.in > Subject: Re: [AI] how to restrict youtube from opening > Message-ID: > <CAF2k8dGoT+votya+Wi66RVQ+HqmxPxjDHH= > qzemq_wh42xy...@mail.gmail.com> > Content-Type: text/plain; charset=ISO-8859-1 > > Oh! no, no, its working but it is asking to type password for each > website and not alone for youtube. Its not enough on the same website > while moving to next or previous link its annoying by asking master > password. It is not better blocking option please suggest some other > option to block youtube from opening in my system. > > On 9/22/12, Shona Man <shonam...@gmail.com> wrote: > > yes this is working, thanx > > > > On 9/21/12, Sheik mohammedali <shahid.se...@gmail.com> wrote: > >> O sorry. > >> folow these steps exactly: > >> go to internet options and go to content tab and hit enter on enable... > >> button and then press control+tab until you get approved sites tab and > >> type > >> > >> the website which you want to block and press tab until you get never > >> button. once you activate "never allow button", you will be asked to > set > >> supervisor's password. then follow the instructions on screen. > >> ----- Original Message ----- > >> From: "Shona Man" <shonam...@gmail.com> > >> To: <accessindia@accessindia.org.in> > >> Sent: Friday, September 21, 2012 4:39 PM > >> Subject: Re: [AI] how to restrict youtube from opening > >> > >> > >>> Hi this method is not working as privacy setting is only about > >>> blocking kukies and not about the blocking the website from opening. > >>> suggest other method please. > >>> > >>> On 9/21/12, Sheik mohammedali <shahid.se...@gmail.com> wrote: > >>>> hello, I don't recommend these browsers settings to restrict the > sites. > >>>> there are some parent utilities which can restrict the contents. > write > >>>> to > >>>> me personally if you need further assistance. > >>>> ----- Original Message ----- > >>>> From: "Phen Varghese" <phenvargh...@gmail.com> > >>>> To: <accessindia@accessindia.org.in> > >>>> Sent: Friday, September 21, 2012 10:22 AM > >>>> Subject: Re: [AI] how to restrict youtube from opening > >>>> > >>>> > >>>>> Hi, > >>>>> > >>>>> Well that is a good info. > >>>>> Well i have a question. > >>>>> What is the method to unblock the site? > >>>>> > >>>>> RGDS, > >>>>> > >>>>> Phen Varghese > >>>>> > >>>>> On 9/21/12, Sheik mohammedali <shahid.se...@gmail.com> wrote: > >>>>>> internet explorer: > >>>>>> go to internet options usually under control pannel or type > >>>>>> inetcpl.cpl > >>>>>> under run. > >>>>>> then, pres control+tab until you get privacy page. then, press tab > >>>>>> until > >>>>>> you get sites... and type the site which you want to block and press > >>>>>> tab > >>>>>> until you get block. > >>>>>> ----- Original Message ----- > >>>>>> From: "Shona Man" <shonam...@gmail.com> > >>>>>> To: "accessindia" <accessindia@accessindia.org.in> > >>>>>> Sent: Thursday, September 20, 2012 11:05 PM > >>>>>> Subject: [AI] how to restrict youtube from opening > >>>>>> > >>>>>> > >>>>>>> Hid friends I am using internet explorer 8 and mozilla 15, I want > >>>>>>> that > >>>>>>> nobody could open youtube from my system because it waste my time. > >>>>>>> So > >>>>>>> friends please guide me how can i restrict youtube from opening in > >>>>>>> these browsers. > >>>>>>> > >>>>>>> -- > >>>>>>> LL.M candidate > >>>>>>> at Faculty of Law in University of Delhi > >>>>>>> > >>>>>>> > >>>>>>> Search for old postings at: > >>>>>>> http://www.mail-archive.com/accessindia@accessindia.org.in/ > >>>>>>> > >>>>>>> To unsubscribe send a message to > >>>>>>> accessindia-requ...@accessindia.org.in > >>>>>>> with the subject unsubscribe. > >>>>>>> > >>>>>>> To change your subscription to digest mode or make any other > >>>>>>> changes, > >>>>>>> please visit the list home page at > >>>>>>> > http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in > >>>>>>> > >>>>>> > >>>>>> > >>>>>> > >>>>>> Search for old postings at: > >>>>>> http://www.mail-archive.com/accessindia@accessindia.org.in/ > >>>>>> > >>>>>> To unsubscribe send a message to > >>>>>> accessindia-requ...@accessindia.org.in > >>>>>> with the subject unsubscribe. > >>>>>> > >>>>>> To change your subscription to digest mode or make any other > changes, > >>>>>> please > >>>>>> visit the list home page at > >>>>>> > http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in > >>>>>> > >>>>>> > >>>>> > >>>>> > >>>>> Search for old postings at: > >>>>> http://www.mail-archive.com/accessindia@accessindia.org.in/ > >>>>> > >>>>> To unsubscribe send a message to > >>>>> accessindia-requ...@accessindia.org.in > >>>>> with the subject unsubscribe. > >>>>> > >>>>> To change your subscription to digest mode or make any other changes, > >>>>> please visit the list home page at > >>>>> > http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in > >>>>> > >>>> > >>>> > >>>> > >>>> Search for old postings at: > >>>> http://www.mail-archive.com/accessindia@accessindia.org.in/ > >>>> > >>>> To unsubscribe send a message to > >>>> accessindia-requ...@accessindia.org.in > >>>> with the subject unsubscribe. > >>>> > >>>> To change your subscription to digest mode or make any other changes, > >>>> please > >>>> visit the list home page at > >>>> > http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in > >>>> > >>>> > >>> > >>> > >>> -- > >>> LL.M candidate > >>> at Faculty of Law in University of Delhi > >>> > >>> > >>> Search for old postings at: > >>> http://www.mail-archive.com/accessindia@accessindia.org.in/ > >>> > >>> To unsubscribe send a message to > >>> accessindia-requ...@accessindia.org.in > >>> with the subject unsubscribe. > >>> > >>> To change your subscription to digest mode or make any other changes, > >>> please visit the list home page at > >>> > http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in > >>> > >> > >> > >> > >> Search for old postings at: > >> http://www.mail-archive.com/accessindia@accessindia.org.in/ > >> > >> To unsubscribe send a message to > >> accessindia-requ...@accessindia.org.in > >> with the subject unsubscribe. > >> > >> To change your subscription to digest mode or make any other changes, > >> please > >> visit the list home page at > >> > http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in > >> > >> > > > > > > -- > > LL.M candidate > > at Faculty of Law in University of Delhi > > > > > -- > LL.M candidate > at Faculty of Law in University of Delhi > > > > End of AccessIndia Digest, Vol 58, Issue 1630 > ********************************************* > Search for old postings at: http://www.mail-archive.com/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in