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