Newbie here. This is what my file looks like:

A1 THIS
A2 ****
A3 ****
A4 ****
A5 ****
A6 THAT
A7 ****
A8 ****
A9 ****
A10 ****
A11 THIS
A12 ****
etc...

What I want to do is write a formula that will determine
the value of the cells in column "b" depending if THIS or THAT
was last read. For example cells A1 - A5 would be value of 1.
A6 - A10 would be 2. A11 - A12 would be 1 again.


I think what I need to do would be create a variable and print that variable
value in column B. The variable would switch values when it read
THIS or THAT. I can write an if statement to create the variable value.
Not sure how to handle the rest. Would I have to use a For Next loop and
step through until I reached the end of my file?


T.I.A.