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
