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!