Keno Formula

You may need to upload a sample file (excel file) giving input and expected output reaults
Thanks

Originally Posted by etm6477

This is basically a two part question. I play Keno often, and am trying to look for patterns.

Perhaps stating the obvious but unless the lottery is rigged you won't. And if you do spot any 'patterns' they'll be illusory and not due to any inherent bias in the system.

Let's say that your have the 20 numbers in columns 83 to 102 (columns CF to CX), starting in Row 2.


Then, in cell B2, enter the formula

=IF(ISERROR(MATCH(COLUMN(A1),$CF2:$CX2,FALSE)),"",COLUMN(A1))

And apply Conditional Formatting using the Formula option, using the formula

=AND(B2<>"",OR(A2<>"",C2<>""))

and select the highlighting that you want to use.

Then copy B2 to C2:CC2.

Finally, copy B2:CC2 down to match your list of numbers in CF:CX

You do know that lotteries are random, so pattern finding won't help you win...

I've good at seeing patterns, and I've noticed it's not random. You're playing against a computer algorithm, and not random balls being drawn. I win $500 more than anyone I know because I group together the runs of 3 and 4 numbers when the numbers all start to come out in the games before, so if game 1 the 8,9 comes out, game 2 the 7,9, and game 3 the 7,8, then usually the 7,8,9 will come out next

Try this file....

Keno Sample 2.xlsx

I think it would be better if you tried by yourself first.

To start, position your set of numbers in the correct columns (the same columns as in my modified file), and just copy the 80 columns of formulas into the correct columns, extending down to match your list of numbers. The formulas and conditional formatting will update to the new rows of the new sheet, so you won't have to do anything else to that set.

For the 20 columns of drawn numbers, copy the first row of numbers from my file, and paste formats over your entire set of data. The CF formulas will update correctly.

If you can't get that to work, post back.

On that sheet that you posted, select cells C14:CD14 and press Ctrl-C to copy.
Then select C16:CD148 and press Ctrl-V to paste.

Then select cells CG14:CZ14 and press Ctrl-C to copy.
Then select cells CG16:CZ148, and right-click your select, then choose the Paste Formats button or use Paste Special... / Formats / OK

If you follow my instructions EXACTLY it would work. You should try again to do it yourself so that you learn how to use Excel.

So, to that end, here is a workbook with simplified instructions - follow the instructions in the colored-in cells.

Keno Sample 4.xlsx

@puroko. This forum can be strict about some of its rules, such as the rule against posting your question in another member's (old) thread. You should start your own thread. If you believe that the information in this thread will be useful to help someone understand your question, you can link to this thread in your new thread.

Navigate to the desired forum (this one seems as good as any https://www.excelforum.com/excel-for...and-functions/ ). Near the top above the list of threads in that forum, on the left, should be a large "+post new thread" button. Click on this button to go to the main post editing page where you can enter your message.

@puroko

please read the forumrules

2. Don't post a question in the thread of another member -- start your own. If you feel it's particularly relevant, provide a link to the other thread. You may include up to 3 links to other URLs in a single post, no more, so only link to the relevant pages.