Occurrence between rows
 

I don't know if this is possible in Excel.....

I have a column 800 rows long. The number 10 occurs 15 times in the
column. What is a function I can use to count the number of rows
between the first instance of the number 10 and the second, third,
fourth, etc...

Thanks for any and all help!

Occurrence between rows
 

Hi Andersons,

try =if(a2=10;Lin();"")

copy it down

hope this helps
Regards from Brazil
Marcelo

" escreveu:

I don't know if this is possible in Excel.....

I have a column 800 rows long. The number 10 occurs 15 times in the
column. What is a function I can use to count the number of rows
between the first instance of the number 10 and the second, third,
fourth, etc...

Thanks for any and all help!