Thanks Ashish
________________________________
From: ashish koul <koul.ash...@gmail.com>
To: excel-macros@googlegroups.com
Sent: Tue, 18 January, 2011 10:53:44 AM
Subject: Re: $$Excel-Macros$$ Array If
TYPE THIS IN B1 =IF(COUNTIF(A1:A1000,"hanumant" )>=1,"true","false")
On Tue, Jan 18, 2011 at 9:48 AM, hanumant shinde <hanumant_5...@yahoo.co.in>
wrote:
Hi Srinivasan,
>
>Thanks for the reply.
>there is no sample data . i just wanna know hw can i know if the specifi value
>(lets say "hanumant") is present in specific range or not (lets say A1:A1000).
>
>so i can say i wanna check IF "hanumant" is present in A1:A1000 range. but i
>dont wanna type any formula in all cells from A1 to A1000. its jus i ll type 1
>formula in B1 and i ll get True or False in B1.
>
>
>
>
________________________________
From: Srinivasan Ethirajalu <srinivasan.ethiraj...@gmail.com>
>To: hanumant_5...@yahoo.co.in; excel-macros@googlegroups.com
>Sent: Mon, 17 January, 2011 9:10:49 AM
>Subject: Re: $$Excel-Macros$$ Array If
>
>
>Hi hanumant,
>
>
>You are checking absolute ranges(A8:A14) with a single value "a". Which is not
>possible.
>Please narrate your requirement as well as send with sample data.
>
>
>
>
>
>
>
>On Mon, Jan 17, 2011 at 1:03 AM, hanumant shinde <hanumant_5...@yahoo.co.in>
>wrote:
>
>Hi Friends,
>>
>>I want to use IF condition like i used below but its no working.
>>I used below formula.
>>={IF($A$8:$A$14="a",1,"")}
>>
>>
>>f
>>d
>>s
>>d
>>f
>>g
>>a .
>>.
>>.
>> and so on
>>
>>this is my data which is random.
>>i want to write if any of the row in above data has "a" then write 1 else 0.
>>if
>>condition will come only once not for all the rows.
>>i dont wanna use macro nor OR as data can be large.
>>
>>Thanks
>>
>>--
>>----------------------------------------------------------------------------------
>>
>>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
>>
>
>
>--
>Srinivasan Ethirajalu,
>+919677042736
>--
>----------------------------------------------------------------------------------
>
>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
>
>
>--
>----------------------------------------------------------------------------------
>
>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
PBefore 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
--
----------------------------------------------------------------------------------
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
