Excel question

[ati]

Is there an easy way to show repeat statistics in excel?
For example, if I put in 10k random numbers, I'd like to see what is the longest series without a repeat, or how many series of x unique numbers can be found.
Any help and guide is appreciated.

[Nickmsi]

Hello . . .

I used the attached Excel Sheet to determine Repeat Numbers, Numbers that Sleep and the # of spins between hits (Gaps).

Hopefully, this code will help you in your searches.

Cheers

Nick

[ati]

Thanks, I'm tryna figure out how it works.

[Nickmsi]

If you need some help with this excel sheet just email me at nickmsi@aol.com and I will do my best to assist.

Cheers

Nick

[nottophammer]

Hi Nick
is there any books on coding in excel. something like excel for dummies,

[shuttle]

Hi NTH

Is this what you are looking for?

link:://:.amazon.co.uk/Excel-2016-Dummies/dp/111907701X/ref=sr_1_1?ie=UTF8&qid=1458865331&sr=8-1&keywords=excel+for+dummies