I have a formula =OR(EXACT(C22,C24:H24)), the next cell is
=OR(EXACT(D22,C24:H24)) then =OR(EXACT(E22,C24:H24)).
The next row has =OR(EXACT(C22,C25:H25)), then =OR(EXACT(D22,C25:H25)) then
=OR(EXACT(E22,C25:H25)).

If I use autofill downwards, it changes the C22 value to C23 then C24 etc I
want the C22 value to remain constant while the C24:H24 bit does increment to
C25:H25 etc.

The purpose of the formula is for checking lottery numbers against a table
of lottery entries. My formula gives me a true/false value.

What I would really like is to be able to put in the numbers to be checked
against my table and get a numeric result showing me how many of my numbers
are in each row of my table.

Please help it is driving me batty.

Thanks
--
When would now be a good time to change?