Re: $$Excel-Macros$$ Code to control the database not to accept repeated number

thank you all very muchh On Fri, Sep 9, 2011 at 10:51 AM, Venkat CV wrote: > Hi Bheema, > > See below image and Try Data Validation and use custom and formula as * > =COUNTIF(C:C,C1)=1* > > [image: image.png] > *Best Regards,* > *Venkat * > *Chennai* > *My Linked in profile

Re: $$Excel-Macros$$ Code to control the database not to accept repeated number

Hi Bheema, See below image and Try Data Validation and use custom and formula as * =COUNTIF(C:C,C1)=1* [image: image.png] *Best Regards,* *Venkat * *Chennai* *My Linked in profile * * * On Tue, Sep 6, 2011 at 8:10 PM, Bheema Shankar wrote: > I

Re: $$Excel-Macros$$ Code to control the database not to accept repeated number

Dear Bheema, Please see attached Sheet... On Tue, Sep 6, 2011 at 8:10 PM, Bheema Shankar wrote: > I made a userform. linked it with the datasheet. the filenumber acts > as a bridge between userform and datasheet. I have to make the file > number unique in excel. Because the duplica

RE: $$Excel-Macros$$ Code to control the database not to accept repeated number

Use COUNTIF to check filenumber is unique : =COUNTIF(the filenumber column,filenumber)=0 Daniel -Message d'origine- De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de Bheema Shankar Envoyé : mardi 6 septembre 2011 16:40 À : MS EXCEL AND VBA MACROS Obje