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 rabinthapa2...@gmail.com Dear all, I have one attach file where I am keeping the

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

2011-03-09 Thread ChilExcel
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 ;

$$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