Lottery exercise

[Mike G]

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

 

[Guest]

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.

 

[Mike G]

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!