Re: finding the no. of rows in a COL filled with numbers, zeros and bl

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Domenic <domenic22@xxxxxxxxxxxx>
Date: Fri, 20 May 2005 19:04:49 -0400

I like this one. Definitely more efficient than the one I offered.
I'll have to remember it. :)

In article <428e6430$0$64595$e4fe514c@xxxxxxxxxxxxxx>,
Aladin Akyurek <akyurek@xxxxxxxxx> wrote:

> E2;
>
> =MATCH(9.99999999999999E+307,A:A)
>
> E3:
>
> =MATCH(REPT("z",255),A:A)
>
> E4:
>
> =IF(COUNT(E2:E3)=2,MAX(E2:E3),SUMIF(E2:E3,"<>#N/A"))
>
> The following would define a dynamic range in A on Sheet1:
>
> =Sheet1!$A$1:INDEX(Sheet1!$A:$A,E4)
.

Follow-Ups:
- Re: finding the no. of rows in a COL filled with numbers, zeros and bl
  - From: Don Guillett

References:
- finding the no. of rows in a COL filled with numbers, zeros and bl
  - From: z.entropic
- Re: finding the no. of rows in a COL filled with numbers, zeros and bl
  - From: Aladin Akyurek

Prev by Date: Re: Sum Activecell Offset Problem
Next by Date: automatically adjust numbers in a column when data is deleted
Previous by thread: Re: finding the no. of rows in a COL filled with numbers, zeros and bl
Next by thread: Re: finding the no. of rows in a COL filled with numbers, zeros and bl
Index(es):
- Date
- Thread