Count Intervals Before Next Occurrence

[jasonsarea]

Hi,
I have a column of single digit numbers. Is it possible to give a formula that counts & lists out the intervals for every number?

I have attached an example.xls file, explaining what it is that I am looking for.

Thanks,

-Jason

[WHER]

See attachment:

[jasonsarea]

Hey WHER,
Thanks a lot for the prompt response. The formula works perfectly.
Cheers,
-JB.