G
Guest
Hello everybody again!! I am using excel 2007. Here is my latest problem.
I have a very large worksheet. Each row is a date from 1/1/1900 through the
present. I have about 600 columns.
What I need to do now is take a certain exisiting column, and then create a
new column based on the data in the old column. The old column has either a
1 or a -1 or a 2 in certain cells, based on various criteria. The new column
must look at the old one, and find the 1, or -1, or 2 and then count down
five rows, and put in a 1. (All dates are not necessarily in. most weekends
and holidays are missing, so I wouldn't really need something based on dates,
simply to count down five rows, and put in the 1) To make this easier, I
would copy the column to a different worksheet, and work with it there and
then insert the new column where I need it. Also, I can also take the
original copied column, and change the 1, or -1 or 2 all to the same thing,
in order to make the new column. I have to find cells that are not blank, and
then based on that, put in the 1 in the new column. Also, not always do I
need five rows down, sometimes I would need 3, or two or 10 or 30, etc.
Sample:
Date: old column new column should end up with:
1/2/1900 1
1/3/1900 1
1/6/1900
1/7/1900 1
1/8/1900 1
1/9/1900 1
1/10/1900 1 1
1/11/1900
1/12/1900 1
1/13/1900 1
1/14/1900
1/17/1900 1
I have a very large worksheet. Each row is a date from 1/1/1900 through the
present. I have about 600 columns.
What I need to do now is take a certain exisiting column, and then create a
new column based on the data in the old column. The old column has either a
1 or a -1 or a 2 in certain cells, based on various criteria. The new column
must look at the old one, and find the 1, or -1, or 2 and then count down
five rows, and put in a 1. (All dates are not necessarily in. most weekends
and holidays are missing, so I wouldn't really need something based on dates,
simply to count down five rows, and put in the 1) To make this easier, I
would copy the column to a different worksheet, and work with it there and
then insert the new column where I need it. Also, I can also take the
original copied column, and change the 1, or -1 or 2 all to the same thing,
in order to make the new column. I have to find cells that are not blank, and
then based on that, put in the 1 in the new column. Also, not always do I
need five rows down, sometimes I would need 3, or two or 10 or 30, etc.
Sample:
Date: old column new column should end up with:
1/2/1900 1
1/3/1900 1
1/6/1900
1/7/1900 1
1/8/1900 1
1/9/1900 1
1/10/1900 1 1
1/11/1900
1/12/1900 1
1/13/1900 1
1/14/1900
1/17/1900 1