Newbie help

[Ed]

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.

 

[Frank Kabel]

Hi
in B1 enter
=IF(A1="THIS",1,IF(A1="THAT",2,""))
and copy this formula down for all rows

 

[Ed]

Frank,

That formula will not make cell A2 the value of 1.

 

[Frank Kabel]

Hi
I thought you want the values in column B?. Could you provide also an
example of your expected result

 

[Linda]

If your only possible data is one of two things (THIS or
THAT), try this formula and copy it down. Add a blank
row at the top so the first formula has a cell to read
(B1).

=IF(A2="THIS",1,IF(A2="THAT",2,B1))
Linda

 

[Ed]

Frank,
You're right, i'm sorry. What I meant to write was "That formula will not
make cell B2 the value of 1".

This should have read B1-B5 would be value of 1.
B6-B10 would be 2.
B11-B12 would be 1 again
and so on.

Sorry for the confusion.

 

[Frank Kabel]

Hi
try the following in B1
=IF(A1="THIS",1,IF(A1="THAT",2,""))

in B2 enter
=IF(A1="THIS",1,IF(A1="THAT",2,B1))
and copy this formula down