how do I control autofill to do my progression?
 

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?

how do I control autofill to do my progression?
 

On Sun, 2 Aug 2009 11:08:01 -0700, The Life Coach
wrote:

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

how do I control autofill to do my progression?
 

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

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


"Lars-Ã…ke Aspelin" wrote:

On Sun, 2 Aug 2009 11:08:01 -0700, The Life Coach
wrote:

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