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

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. :-)

thechilipino Wrote:
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




--
cvhelios
------------------------------------------------------------------------
cvhelios's Profile: http://www.excelforum.com/member.php...o&userid=19995
View this thread: http://www.excelforum.com/showthread...hreadid=528461