Occurrence between rows

[[email protected]]

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!

[Marcelo]

Hi Andersons,

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

copy it down

hope this helps
Regards from Brazil
Marcelo

"[email protected]" 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!
>
>