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.