How to make COUNT indicate ROW

I have an essential question:
If I have an excel sheet with, let's say 10.000 rows, and numbers are filled in one row and let's say, about 5.000 are numbers scattered downwards from array D8:D10000, how can I tell which ROW COUNT has reached e.g. 1000 numbers or 2000 numbers?
I'd be very grateful for an answer to this.

K. I. Malde, Norway

hi k.i.:

one possibility is in column E to use counta(E$8:E8) & copy down the length
of the array. then off to the right type in 1000 and 2000 in cells H2 & H3
for example. then use the match(H2,$E$8:$E$10000,0) function to find which
row those numbers appear.

i hope that helps.

cheers.



"cvhelios" wrote:

>
> I have an essential question:
> If I have an excel sheet with, let's say 10.000 rows, and numbers are
> filled in one row and let's say, about 5.000 are numbers scattered
> downwards from array D8:D10000, how can I tell which *ROW* COUNT has
> reached e.g. 1000 numbers or 2000 numbers?
> I'd be very grateful for an answer to this.
>
> K. I. Malde, Norway
>
>
> --
> cvhelios
> ------------------------------------------------------------------------
> cvhelios's Profile: http://www.excelforum.com/member.php...o&userid=19995
> View this thread: http://www.excelforum.com/showthread...hreadid=528461
>
>

Well.... I have identified that kind of solution using the OFFSET function and just counting up from row to row, but I feel this takes so much space. 1 column of nearly 10.000 cells took nearly 1,3 MB of space alone.
I was more looking for a function that in a few cells culd tell me which rows the round numbers of 1000 counts and 2000 counts, and so on, where. Thanks for you help anyway.

Cheers. :-)

Originally Posted by thechilipino

hi k.i.:

one possibility is in column E to use counta(E$8:E8) & copy down the length
of the array. then off to the right type in 1000 and 2000 in cells H2 & H3
for example. then use the match(H2,$E$8:$E$10000,0) function to find which
row those numbers appear.

i hope that helps.

cheers.



"cvhelios" wrote:

>
> I have an essential question:
> If I have an excel sheet with, let's say 10.000 rows, and numbers are
> filled in one row and let's say, about 5.000 are numbers scattered
> downwards from array D8:D10000, how can I tell which *ROW* COUNT has
> reached e.g. 1000 numbers or 2000 numbers?
> I'd be very grateful for an answer to this.
>
> K. I. Malde, Norway
>
>
> --
> cvhelios
> ------------------------------------------------------------------------
> cvhelios's Profile: http://www.excelforum.com/member.php...o&userid=19995
> View this thread: http://www.excelforum.com/showthread...hreadid=528461
>
>