finding number series in an array
I have an exercise to solve.
in the lottery, each week 6 random numbers from 1-37 are chosen.
I have the last 15 weeks lottery numbers that won.
I need to find 12 numbers that will maximize the weeks that all 6 random numbers are between those 12 numbers
meaning I have an array of 15 rows and 6 numbers in each row all numbers are from 1-37
I want to find 12 numbers that will maximize the times that all 6 numbers in a row are in those 12 numbers
can it be done in excel?
Last edited by kman; 05-07-2013 at 08:48 PM.
Please use [CODE]-TAGS
When your problem is solved mark the thread SOLVED
If an answer has helped you please click to give reputation
Read the FORUM RULES
Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.
Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
you just counted how may occurs each number has...
I need to find 12 numbers
that will get me the most matches to all 6 numbers in the row
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1