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!