loop calculations in excel?

[Guest]

Hi,
I have several colums of data (colum A, B C..), and each has about 1000
points of data. Each column has some missing points(blanks), represented
as"---". I want to create a label (a new column)for each column;i.e., when
A(2) ,A(9),A(20)...is "---", the label(2),label(9),label(20)...=-1, otherwise
the lable=1. It is like a loop thing. I wanted to make a little program about
this. Could anyone give a little help? Thanks in advance!
BTW, to run the program, is it a good idea to insert the code as a module
and then run it? I never did this before in Exel, and would appreciate a lot
if you guys can give some details about how to run! Thanks!

 

[Chip]

shannon..i can help you but i dont understand the question yet...so you
want whenever column A entries are "---", you want the corresponding
cell in the label column to read "-1", otherwise it should read "1"?
And what column will the label column be (i.e. Column L)?

 

[Myrna Larson]

Why do you want to do this with VBA? A simple formula in your label columns
will do, i.e. =IF(A1="---",-1,1)