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

[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.com/user/timextag41
>
>
> 2011/3/8 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 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

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

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

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


PIPE DATA RECORD FILE_REPEAT ALERT.xls
Description: MS-Excel spreadsheet

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

[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.
>
>
>
> 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
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

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


PIPE_DATA_RECORD_FILE(1).xls
Description: MS-Excel spreadsheet

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

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


PIPE DATA RECORD FILE.xls
Description: MS-Excel spreadsheet