Re: $$Excel-Macros$$ Please help on Excel.

2011-03-09 Thread ChilExcel
sorry, use this formula in data validation =CONTAR.SI ($C$2:$C$30;C2)=1 2011/3/9 ChilExcel > 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

Re: $$Excel-Macros$$ Please help on Excel.

2011-03-09 Thread ChilExcel
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 > Dear all, > > > > I have one attach file where I am keeping the serial pipe number b

Re: $$Excel-Macros$$ Please help on Excel.

2011-03-08 Thread ashish koul
see if it helps On Tue, Mar 8, 2011 at 8:51 PM, Rabindra Thapa wrote: > 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

$$Excel-Macros$$ Please help on Excel.

2011-03-08 Thread Rabindra Thapa
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