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

--
Regards
Frank Kabel
Frankfurt, Germany


Ed wrote:
Frank,

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




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

--
Regards
Frank Kabel
Frankfurt, Germany


Ed wrote:
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.