RE: Lottery exercise

Put your 18 numbers (3x6) into cells A1 thru A18. Put your database into say
C1 thru C1000. In B1 put =COUNTIF(C1:C1000,"="&A1) and copy down thru B18.


For each entry in column A you will now know if the number appears in the
database and how many times it appears.
--
Gary's Student


"Mike G" wrote:

> I buy 3 tickets, 6 numbers each and want to compare them with a data base of
> past winners. Conditional formating only allows 4 instances, (was wanting
> to change format of data base in which numbers match i.e. turn red or??)
> Should be easy.....but I am stumped. TIA
>
>
>

Tried that and here is what I got:
A B C
1 1 9
2 0 5
3 0 5
4 0 7
5 0 9
6 0 1
7 4 13
8 0 15
9 4 17
10 0 7
11 0 18
12 0 7
13 0 9
14 0 7
15 0 9
16 0 7
17 0 9
18 0 9

Clearly not doing what I want!

"Gary''s Student" <[email protected]> wrote in message
news:[email protected]...
> Put your 18 numbers (3x6) into cells A1 thru A18. Put your database into
> say
> C1 thru C1000. In B1 put =COUNTIF(C1:C1000,"="&A1) and copy down thru
> B18.
>
>
> For each entry in column A you will now know if the number appears in the
> database and how many times it appears.
> --
> Gary's Student
>
>
> "Mike G" wrote:
>
>> I buy 3 tickets, 6 numbers each and want to compare them with a data base
>> of
>> past winners. Conditional formating only allows 4 instances, (was
>> wanting
>> to change format of data base in which numbers match i.e. turn red or??)
>> Should be easy.....but I am stumped. TIA
>>
>>
>>