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
