how do I control autofill to do my progression?

[The Life Coach]

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

 

[Lars-Åke Aspelin]

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

If you change the C22 to C$22 it will NOT change when you copy down.

Hope this helps / Lars-.Åke

 

[The Life Coach]

Lars-.Ã…ke, thank you, it helps enormously, not just here bu in lots of my
other sheets. Thank you again.

Andy