EXCEL Qre: FREQUENCY and COUNT functions...

Reply #9

RJOh — Sat, 16 Aug 2008 03:32:09 GMT

Sounds like you're on your way. As far as books to read, I can't recommend any, most cover stuff you probably already know if you've been playing and hanging around LP for a while.

Reply #8

CurtisC — Sat, 16 Aug 2008 02:53:40 GMT

Greetings RJOh,

Sorry about not getting back sooner - reading - learning, a piece by piece... haven't had time to bear-down on Excel, yet - seems to be a necessary tool to have in the kit.

Ran across the name Ion Saliu who has Excel based programs.

Now that I've looked deep into the abyss, can't imagine being in a position to make claims anytime soon... cruizin' the forums and threads is edifying; yeah, there are more than a few very bright, dead serious gamers - I'm starting to pick-u... [ More ]

Reply #7

RJOh — Mon, 11 Aug 2008 03:33:29 GMT

Any time someone tries to develop a method to anticipate the outcomes of a lottery drawing, they've chosen a big task. There are a few LP members who claim to have invested the effort and come close enough to be in the ball park nearly every drawings and it's just a matter of time before they hit a home run and it all pays off. Good luck to you, maybe someday you'll be making the same claim.

Reply #6

CurtisC — Fri, 08 Aug 2008 02:10:10 GMT

Thank you, LottoL... Appreciate it.

Suddenly, the game's bigger than I imagined. Howard's books should be it soon... w/ generous links and materials LP'ers been providing: got my work cut-out. Joss.

Reply #5

LottoL — Tue, 05 Aug 2008 22:43:54 GMT

Advice, anyone?

Thank you.

CurtisC,

You might want to try Allen Wyatt's Excel Tips Website.

They may have what you are looking for.

http://exceltips.vitalnews.com/

Good Luck!

LottoL

Reply #4

CurtisC — Tue, 05 Aug 2008 17:05:55 GMT

Thank you sysp34. I will take a look. Sincere appreciation for your assist. Luck.

Reply #3

CurtisC — Tue, 05 Aug 2008 16:43:19 GMT

I did not think to run a search on the function name.

I'm beginning to see the layered depth in LP.

A debt of gratitude, time*treat

Reply #2

sysp34 — Tue, 05 Aug 2008 12:20:11 GMT

Curtis C

although i don't know about an array maybe you can develop this simple formula from this spreadsheet

download link

note:

the file renamed from *.7z into *.zip due to security on LP website, use 7zip software to extract the files and please support the author for further development

good luck

Reply #1

time*treat — Mon, 04 Aug 2008 21:43:39 GMT

https://www.lotterypost.com/search.asp?q=countif t=2y

EXCEL Qre: FREQUENCY and COUNT functions...

CurtisC — Mon, 04 Aug 2008 16:50:00 GMT

I want to take an array of random numbers, say 30 x 30 rows/columns, and find frequency/count/reoccurrence of each number in the array.

Not sure how to setup/apply the formulae functions.

Excel has COUNT and FREQUENCY options, but I haven t been able, capable of avoiding errors. HELP is not much help and the 3 Disc Video Professor tutorials that came w/ the application don t cut-it.

I m working on an idea promise to share results on LP, if worthy.

Advice, anyone