There are no formula or data validation in file!! Best Regards, Amit Desai Assistant Manager, GKS Direct +91 22 6672 9855 Mobile +91 9867232534 <mailto:vinod.das...@bdoindia.co.in> amit.de...@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 <http://www.bdoindia.co.in/> www.bdoindia.co.in 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
<<image001.jpg>>
