I need it to do a rundown until the number repeats itself

[piter]

I need it to do a rundown until the number repeats itself... so for example...

Number drawn is
126
adding 111 would create
126
237
348
459
560
671
782
893
904
015
126 ... repeated from initial number...

soma 111

MediaFire is a simple to use free service that lets you put all your photos, documents, music, and video in a single place so you can access them anywhere and share them everywhere.

www.mediafire.com

 

[Fluff]

Can you please update your account details to show which version of Excel you are using, as this affects what functions you can use.

Also please post sample data using the XL2BB add-in.
That way members can copy/paste the data straight into Excel, without having to download workbooks from an external site.