help with Excel!

Reply #9

jm6256 — Mon, 04 May 2009 01:56:23 GMT

thanks for the help P8

Reply #8

phileight — Sun, 03 May 2009 17:21:00 GMT

JM

heres a vba solution. put your numbers to be checked in row 1 col's EFG all boxed or str comb will be displayed startin in row 4 then exact order will be displayed starting in col E

I always recommend you copy your data to a new name, then close the original and work with the copy. if you don't like the results just delete and all is well.

I apologise if you already know all of this, but untill recently I could not comprehend these first few steps and wasted years continuing to work... [ More ]

Reply #7

jm6256 — Sun, 03 May 2009 15:36:06 GMT

thanks winsumloosesum, I have history from 2002. which is why I was looking for a way to look into numbers of days since a number was drawn (probably will use it for box and double) for now.

Reply #6

winsumloosesum — Sun, 03 May 2009 15:26:50 GMT

I should have added this in the previous post. When you are using the Match formula for finding how many drawings since a combination hit, the result from the formula may reult in a NA because of the limited number of past drawings in your history range. Especialy straight combinations. Some states may have a straight combination out 6000 or more draws. For boxed combinations you would need probably a smaller history.

You could use this formula in cell B1:

=IF(ISNA(MATCH(A$1,INDIRECT( K20

Reply #5

winsumloosesum — Sun, 03 May 2009 15:11:36 GMT

Answer question #2

=MATCH($A1,INDIRECT( K20:K120 ),0)-0

Ok, if you have the combination 368 in cell A1 and all your past results in cell range K20 through K120 (see formula above). You can increase K120 depending how many lines of past history draws. For example you could have a cell range of K20:K5000. The K = cell range is where you have your 3 digit combination results.

Answer to question #1

Depending on what version of Excel you are using. I am using 2002.

I use a free ad... [ More ]

Reply #4

phileight — Sun, 03 May 2009 12:18:23 GMT

JM

am I correct in that you want to find any previous box match for a specific #, and that changing the order from low to high was just a step in the process? I do this with a VBA if you want to consider a vba solution

p8

Reply #3

jm6256 — Sun, 03 May 2009 11:28:34 GMT

thanks Texas MadMan i'll give it a try

Reply #2

Texas MadMan — Sun, 03 May 2009 07:20:18 GMT

2) how would you figure out longest day out for a number in excel. (not frequency how many time it was drawn) but how long has it been since last drawn.

I use the MATCH function to look through a column of numbers and match what I lookin' for......look in Excel's help files for the MATCH function and it should help you out

Reply #1

Texas MadMan — Sun, 03 May 2009 07:18:03 GMT

Hi, jm, let's see if I can point you in the right direction....

1) if cell A has 638 which formula can I use to sort it (368)

You have to break the # (638) down to it's individual numbers and then sort them small to large (at least that's what it sounds like you want)

-the MID function in excel can select individual characters from a cell, ie. MID(A1,1,1)......would return the 1st character from cell A1 and it would only return that one where MID(A1,2,2) would return the characters star... [ More ]

help with Excel!

jm6256 — Sun, 03 May 2009 05:45:09 GMT

can anyone help me with 2 problems

1) if cell A has 638 which formula can I use to sort it (368)

2) how would you figure out longest day out for a number in excel. (not frequency how many time it was drawn) but how long has it been since last drawn.

thanks

Jim