Randbetween alternative for generating continuous numbers (single cell)

Hi,

I wondered if the folloiwng is possible within excel

Currently, pressing F9 with the following formula: RANDBETWEEN(0,10)

Will generate a series of random numbers i.e. 4,2,7,1,8,9,1,5,10,3,

However is there a formula where if I press F9, the sequence can be continuous rather than random:

i.e. 1,2,3,4,5,6,7,8,9,10,1,2,3,4,5,6....

Or is this only possible using Vba?

Thanks

Mdn

Genius!!

Many thanks shg

Very cool. I had the MOD part but couldn't figure out the incrementing with refresh (F9) part (by allowing iterations). I learned something cool today, so today is a success and now I can go back to bed. Thanks!