Solution for Query 1:- Switch to the "Input Message" page of the Data Validation dialog box using CTRL+TAB and uncheck the check box labeled "Show input message when cell is selected".
Solution for Query 2:- You just want to delete data from one of the cells containing a combo box. Press DELETE key to do so. If you want to remove a month from the list then you can delete it from Data Validation settings. -- Regards, Zujar... An optimist laughs to forget, whereas a pessimist forgets to laugh! -----Original Message----- From: Mukesh [mailto:mukeshbaviskar....@gmail.com] Sent: Wednesday, September 26, 2012 7:13 AM To: accessindia@accessindia.org.in Cc: Zujar Shabbir Kanchwala Subject: Re: [AI] excel formula correction Hello Zujar, Thank you for your guidance. It is working fine but I have a problem, when we go to that particular cell the jaws speaks the formula which I found irritating/unnecessary. How to stop it? Secondly, I have created a dropdown list in excel column 'j' of months. I want to cancel the entry of that month and want to leave it blank. How to cancel the entry, but not dropdown list? Thank you. Regards Mukesh Baviskar -------------------------------------------------- From: "Zujar Shabbir Kanchwala" <zujarbri...@gmail.com> Sent: Monday, September 24, 2012 11:40 AM To: <accessindia@accessindia.org.in> Subject: Re: [AI] excel formula correction > Hi Mukeshji, > > The COUNTIF() function can be made use of in data validation for the > range of cells that are supposed to avoid duplicate entries. Here's > the > procedure: > > 1. Select the range of cells that should avoid duplication. I am > selecting > J2:j201 for illustrative purpose > 2. Press ALT+D followed by L to open Data Validation dialog box for > the selected cells. > 3. TAB to the Allow combo box and select Custom. > 4. TAB to the Formula edit box and enter the following formula: > > =COUNTIF($J$2:$J$201, J2) = 1 > > (The spaces in the above formula are just for clarity, they may be > ignored) > > 5. Activate the OK button. > > Note that this method helps you avoid duplication in the given cell > range but doesn't allow other validations on them. I think there's a > better method that can help us avoid duplication as well as perform > other data validation > - please help if someone on the list knows about it. > > -- > Regards, > Zujar... > > An optimist laughs to forget, whereas a pessimist forgets to laugh! > > > > -----Original Message----- > From: AccessIndia [mailto:accessindia-boun...@accessindia.org.in] On > Behalf Of Mukesh > Sent: Monday, September 24, 2012 8:04 AM > To: Access India > Subject: Re: [AI] excel formula correction > > > > > From: Mukesh > Sent: Monday, September 24, 2012 5:56 AM > To: Mukesh > Subject: Re: excel formula correction > > > Hello Friends, > Sorry for trouble. Now I realized my mistake in formula and I have > corrected > it successfully. With your kind cooperation and guidance I have completed > my > database today. Now I have a problem of prevent duplicate entry only. If > anyone of you know how to prevent duplicate entry rather than removing it > later using remove duplicate function in excel. Waiting to get a positive > guidance from you to complete my database today. Thank you. > > Regards > > Mukesh Baviskar > Mobile: 9403161157 > > > From: Mukesh > Sent: Sunday, September 23, 2012 8:44 PM > To: Access India > Subject: excel formula correction > > > Dear Friends, > I have created a formula in excel but I found a error in which I can not > identify. Therefore I request all of you to correct my mistake in the > following formula. > > =COUNTIF(AN5:AN1000,"NSKMVIJAN",COUNTIF(AN5:AN1000,"NSKMVIFEB",COUNTIF(AN5:A > N1000,"NSKMVIMAR",COUNTIF(AN5:AN1000,"NSKMVIAPR",COUNTIF(AN5:AN1000,"NSKMVIM > AY",COUNTIF(AN5:AN1000,"NSKMVIJUNE",COUNTIF(AN5:AN1000,"NSKMVIJULY",COUNTIF( > AN5:AN1000,"NSKMVIAUG",COUNTIF(AN5:AN1000,"NSKMVISEPT",COUNTIF(AN5:AN1000,"N > SKMVIOCT",COUNTIF(AN5:AN1000,"NSKMVINOV",COUNTIF(AN5:AN1000,"NSKMVIDEC"))))) > ))))))) > Waiting for your correction tomorrow. 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 > > > > 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
