unt intial #NA in a row using excel function
Dear Asa,
Only below formula is getting the desired result, but why you further
enhanced your formula, I am not understanding, can you brief.
=FREQUENCY(IF(ISNA($A$1:$L$1),COLUMN($A$1:$L$1)),IF(NOT(ISNA($A$1:$L$1))
Regards,
Aamir Shah
Another one... without volatile function :)
=COUNTIF(INDEX(A1:L1,LOOKUP(9.999E+307,CHOOSE({1,2},0,MATCH(TRUE,INDEX(ISNA(A1:L1),0),0:INDEX(A1:L1,MATCH(TRUE,INDEX(NOT(ISNA(INDEX(A1:L1,LOOKUP(9.999E+307,CHOOSE({1,2},0,MATCH(TRUE,INDEX(ISNA(A1:L1),0),0)))+1):L1)),0),0)),"#N/A")
Normal enter
Kris
Rossoff
Subject: RE: $$Excel-Macros$$ Count intial #NA in a row using excel function
To: excel-macros@googlegroups.com
Date: Saturday, 21 April, 2012, 0:30
Hello Divaker!
You provided very little information about your need.
My reading of the subject line of your message ("Count in
excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Divaker Pandey
Sent: Apr/Fri/2012 05:59
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Count intial #NA in a row using excel function
thank for reply noorain, but is it possible with any excel fun
t; ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Divaker Pandey
> *Sent:* Apr/Fri/2012 05:59
>
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Count intial #NA in a row using excel
> function
Try with CSE
=SUM(IF(NOT(ISERROR(A1:L1)),A1:L1))
Rajan.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Divaker Pandey
Sent: Apr/Fri/2012 05:59
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Count intial #NA in a row using excel
=SUMPRODUCT(--ISNA(A1:Z1))
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Divaker Pandey
Sent: Friday, April 20, 2012 7:28 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Count intial #NA in a row using excel function
thank for
thank for reply noorain, but is it possible with any excel function
i want to avoid macro
it will be very gr8 help if you response early.
Thanks .
On Fri, Apr 20, 2012 at 5:45 PM, NOORAIN ANSARI wrote:
> Dear Divaker,
>
> Please try it..
>
> Function Initial_Count(rng As Range)
> i = 0
> For Eac
Dear Divaker,
Please try it..
Function Initial_Count(rng As Range)
i = 0
For Each cell In rng
If IsError(cell) = False Then
Exit For
End If
i = i + 1
Next
Initial_Count = i
End Function
See attached sheet..
Thanks & regards,
Noorain Ansari
On Fri, Apr 20, 2012 at 5:06 PM, Divaker Pandey wrote
