now chk...
Regards, Manoj Kumar On Tue, Jan 18, 2011 at 5:36 PM, Amit Desai <amit.de...@bdoindia.co.in>wrote: > There are no formula or data validation in file!! > > > > Best Regards, > > > > Amit Desai > > Assistant Manager, GKS > > Direct +91 22 6672 9855 > > Mobile +91 9867232534 > > amit.de...@bdoindia.co.in <vinod.das...@bdoindia.co.in> > > > > BDO Consulting Pvt. Ltd. > > 701, Leela Business Park, > > Andheri Kurla Road, > > Andheri (E), Mumbai - 400 059. > > INDIA > > Office +91 22 6672 9999 > > Fax +91 22 6672 9777 > > www.bdoindia.co.in > > > > [image: cid:image003.jpg@01CA83EB.7BB89CD0] > > > > BDO Consulting Private Limited, a private limited company incorporated in > India, is a member of BDO International Limited, a UK company limited by > guarantee, and forms part of the international BDO network of independent > member firms. > > > > BDO is the brand name for the BDO network and for each of the BDO Member > Firms. > > > > This message is intended only for the use of the individual or entity to > which it is addressed, and may contain information that is privileged, > confidential or exempt from disclosure under applicable law. If you are not > the intended recipient, any dissemination, distribution or copying of this > communication is strictly prohibited. If you received this communication in > error, please notify BDO immediately and permanently delete or destroy all > copies of the original message and attachments. Whilst this e-mail message > has been swept by anti-virus software, the recipient is solely responsible > for ensuring that any e-mail or attachment the recipient receives, is virus > free. The sender disclaims liabilities for any damages the recipient suffers > as a consequence of receiving any virus through this mail. > > > > *From:* Manoj kumar [mailto:manoj.vishwakarma...@gmail.com] > *Sent:* Tuesday, January 18, 2011 5:31 PM > *To:* excel-macros@googlegroups.com; amit.de...@bdoindia.co.in > *Subject:* Re: $$Excel-Macros$$ Data Validation - No Repitation of data & > avoid blank > > > > see if this helps you... > > > Regards, > Manoj Kumar > > On Tue, Jan 18, 2011 at 1:03 AM, <amit.de...@bdoindia.co.in> wrote: > > Dear Masters, > > > > I have one issue.. > > > > I am creating one file & wants to use data validation with list (giving > name to a range of vendor). My data sheet contains few columns. Column A - > Vendor name, B - service type. As one vendor may provide I have 2 or more > options in column B against same vendors. Thus my list or say name range > covers Vendor name more than once. I want to avoid this in data Validation. > I want to see Vendor's name only once & not more than that (as like > filter). > > > > Also I do not want to see any blank cell as an option in data validation > cells. > > > > Kindly reply. > > > > Best Regards, > > Amit Desai > > > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > > > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
GG_Datavalidation for dupes and Blank cells_Manoj.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
