Text only | Text with Images

#1 Roulette Forum & Message Board | www.RouletteForum.cc

Roulette-focused => General Discussion => Topic started by: ati on Jul 14, 08:15 AM 2015

Title: Excel question
Post by: ati on Jul 14, 08:15 AM 2015
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.
Title: Re: Excel question
Post by: Nickmsi on Jul 14, 10:37 AM 2015
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
Title: Re: Excel question
Post by: ati on Jul 15, 02:33 PM 2015
Thanks, I'm tryna figure out how it works.
Title: Re: Excel question
Post by: Nickmsi on Jul 15, 02:53 PM 2015
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
Title: Re: Excel question
Post by: nottophammer on Mar 24, 07:25 PM 2016
Hi Nick
is there any books on coding in excel. something like excel for dummies,
Title: Re: Excel question
Post by: shuttle on Mar 24, 08:23 PM 2016
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
Text only | Text with Images