making a new column based on data in an existing column
 

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

--
newyorkjoy
thanks for the help!

making a new column based on data in an existing column
 

If your numbers start in A2:

=if(isblank(A2),"",A2)

Enter it however many rows down from row 2 you need, and copy it
downward.

- David

On Aug 1, 11:20 am, newyorkjoy
wrote:
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

--
newyorkjoy
thanks for the help!

making a new column based on data in an existing column
 

Sorry, should of course be:

=if(isblank(A2),"",1)


On Aug 1, 3:21 pm, David Hilberg wrote:
If your numbers start in A2:

=if(isblank(A2),"",A2)

Enter it however many rows down from row 2 you need, and copy it
downward.

- David

On Aug 1, 11:20 am, newyorkjoy
wrote:

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

--
newyorkjoy
thanks for the help!

making a new column based on data in an existing column
 

Thank you, but I also want to know if there is a way to put in the formula
that it should go down five rows, and then put in the formula only in the
fifth row. (So I don't have to count it manually each time. )

Thank you!!
--
newyorkjoy
thanks for the help!


"David Hilberg" wrote:

Sorry, should of course be:

=if(isblank(A2),"",1)


On Aug 1, 3:21 pm, David Hilberg wrote:
If your numbers start in A2:

=if(isblank(A2),"",A2)

Enter it however many rows down from row 2 you need, and copy it
downward.

- David

On Aug 1, 11:20 am, newyorkjoy
wrote:

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

--
newyorkjoy
thanks for the help!

making a new column based on data in an existing column
 

Can someone please continue answeing my questions? Thank you.
--
newyorkjoy
thanks for the help!


"newyorkjoy" wrote:

Thank you, but I also want to know if there is a way to put in the formula
that it should go down five rows, and then put in the formula only in the
fifth row. (So I don't have to count it manually each time. )

Thank you!!
--
newyorkjoy
thanks for the help!


"David Hilberg" wrote:

Sorry, should of course be:

=if(isblank(A2),"",1)


On Aug 1, 3:21 pm, David Hilberg wrote:
If your numbers start in A2:

=if(isblank(A2),"",A2)

Enter it however many rows down from row 2 you need, and copy it
downward.

- David

On Aug 1, 11:20 am, newyorkjoy
wrote:

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

--
newyorkjoy
thanks for the help!