Thanks Ashish
From: ashish koul
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,
Dear Hanumant,
check it: =IF(COUNTIF($A$1:$A$1000,"*hanumant*"
)>=1,COUNTIF($A$1:$A$1000,"*hanumant*" ) & " Times available","Not Present")
Regards
Thamu
On Tue, Jan 18, 2011 at 12:58 PM, Ankur Saraswat wrote:
> Hi Hanumant,
>
> Try it: =IF(A1:A14="a",1,"0")
>
>
>
>
> On Mon, Jan 17, 2011 at
Hi Hanumant,
Try it: =IF(A1:A14="a",1,"0")
On Mon, Jan 17, 2011 at 1:03 AM, hanumant shinde
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
Hi Hanumant,
use it like IF($A$8 ="a",1,"") and drag the formula till A14 or till last
row it will give u 1 only if the cell will contain "a".
Try this out.
Rgds,
Mayank
On Mon, Jan 17, 2011 at 1:03 AM, hanumant shinde
wrote:
> Hi Friends,
>
> I want to use IF condition like i used below but i
B1 and i ll get True or False in B1.
>
>
> --
> *From:* Srinivasan Ethirajalu
> *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 han
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
To: hanumant_5...@yahoo.co.in; excel-macros@googlegroups.com
Sent: Mon, 17 January, 2011 9:10:49 AM
Subject
USE THIS
=IF(A$8$:$A$14="a",1,"")
If u want to use as an array use cntr+shift+enter. It will give u proper
result.
Thanks & Regards,
C.G.Kumar
On Mon, Jan 17, 2011 at 1:03 AM, hanumant shinde
wrote:
> Hi Friends,
>
> I want to use IF condition like i used below but its no working.
> I used be
HI,
This might help u...
Regards,
Manoj Kumar
On Mon, Jan 17, 2011 at 1:03 AM, hanumant shinde
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
>
> thi
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
wrote:
> Hi Friends,
>
> I want to use IF condition like i used below but it
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 com
10 matches
Mail list logo
