Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lotto numbers
I have a Draw Number in column (A), Draw Dates in (B), Draw Numbers
which are in random order in(C:H), and the current Draw Numbers in (K:P) I am using two formulas, which work perfect: {=SUMPRODUCT(--(MMULT(-- ISNUMBER(MATCH(C2:H2000,K2:P2,0)),TRANSPOSE(COLUMN (C2:H2000)^0))=5))} - that one shows me how many sets of 5 numbers of given combination were drawn before and the second formula: Conditional Formatting =AND(C2<"",OR(C2=$K $2:$P$2)), which highlights all the winning numbers. -Question : Because of the very long list of the previous draws ( about 2000) how could I change existing formulas so I have a list of the dates of instances when set of 5 numbers were drawn? At the moment it tels me that set of 5 given numbers were drawn for example twice before. But I have to scroll down through 2000 records to find 5 highlighted numbers. A B C D E F G H K L M N O P 220 6/01/08 3 4 19 21 25 32 2 10 16 24 38 44 221 6/08/08 24 25 38 8 10 7 222 6/15/08 12 23 28 38 22 15 223 6/22/08 37 16 45 14 38 10 Your help is appreciated. Thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Checking Lotto numbers | Excel Worksheet Functions | |||
Lotto template | New Users to Excel | |||
uk lotto dream numbers | New Users to Excel | |||
Lotto Number Checker | Excel Worksheet Functions | |||
Lotto Number Array | Excel Worksheet Functions |