sorry, use this formula in data validation =CONTAR.SI <http://contar.si/>($C$2:$C$30;C2)=1
2011/3/9 ChilExcel <chilexcel...@gmail.com> > Hi > > use this formula in data validation > > =CONTAR.SI($C$2:$C$30;C1)=1 > > > > chilexcel > > > Visita ; http://sites.google.com/site/chilexcel/Home > Visita ; http://www.youtube.com/user/timextag41 > > > 2011/3/8 Rabindra Thapa <rabinthapa2...@gmail.com> > > Dear all, >> >> >> >> I have one attach file where I am keeping the serial pipe number but the >> problem is I am getting the same pipe number many times and it’s hard to >> search whether provide pipe number are reported or not. >> >> >> >> Can u have any formula/validation i.e. when I type the reported pipe >> number its show me the pipe number has been already reported etc or not >> accept the pipe number to entry in file. >> >> >> >> For more detail please look the attach sheet. If u can, please create the >> formula on attach file and revert me. >> >> >> >> >> >> >> >> Hope to get your kind suggestion.. >> >> >> >> Thank you >> >> Rabindra >> >> >> >> >> >> -- >> >> ---------------------------------------------------------------------------------- >> 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 >> > > > > -- > Visita ; http://sites.google.com/site/chilexcel/Home > Visita ; http://www.youtube.com/user/timextag41 > > -- Visita ; http://sites.google.com/site/chilexcel/Home Visita ; http://www.youtube.com/user/timextag41 -- ---------------------------------------------------------------------------------- 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