How to make COUNT indicate ROW

C

cvhelios

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

K. I. Malde, Norwa
 
T

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.
 
C

cvhelios

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

Cheers. :)
hi k.i.:

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

i hope that helps.

cheers.
Click to expand...
 
Top