Thread: Auto Calculate depending on cell generated

Hi
I want to tell you that this is confusing but I will do my best to explain you
I am generating data on column A
it will start at A7 down to whatever limit user enter it, it can be ANY
may be A700 or A50 or A5 or A55 or 242 ETC

so A7 to whatever will generate one of following in to the cell
either CLOSE OR OPEN
so it might look like

A7: OPEN
OPEN
OPEN
OPEN
OPEN
CLOSE
OPEN
CLOSE
OPEN
OPEN
CLOSE
A18:OPEN

in column B I am trying to count the changes that happened in column A from Cell A7 to A#

so in column B I am compaing
=IF(A8=A7,0,1)
=IF(A9=A8,0,1)
=IF(A10=A9,0,1)
=IF(A11=A10,0,1)
=IF(A12=A11,0,1)
=IF(A13=A12,0,1)
=IF(A14=A13,0,1)
=IF(A15=A14,0,1)
=IF(A16=A15,0,1)
=IF(A17=A16,0,1)
=IF(A18=A17,0,1)
so it will compare two cell to see if they are same if they are same it will output 0 if not it will output 1, my problem is I do not know the limit meaning user can enter limit which might go from A7 to A200, I do not want to go back to column B and reenter the formula's to check the changes it should automatically detect that A is going from A7 to A200 so it should generate fromula automatcailly
please help me do this
Thank you

Hey
tht thread for only to know how to calculate
this one I got formula and everything I need for it to work but it has to do with limit