Hello,

I have a formula in a column that determines when a machine should be
turning on and off based on data from another column. When the criteria is
met, the formula writes the word "Start" in the cell. How do I write a
formula in the next column over so that if the word "Start" shows up in
Column 2, I want the next 5 rows down in Column 3 to have the word "Start"
too.

For example:
Column1 Column2 Column3
1 Start Start
2 Start
3 Start
4 Start
5 Start
6 etc......
7

In C1 enter =IF($B$1="Start",$B$1,"")

Copy down to C5

If etc.... in C6 means something, please explain.


Gord Dibben MS Excel MVP

On Sun, 26 Nov 2006 12:04:02 -0800, Machineman
wrote:

Hello,

I have a formula in a column that determines when a machine should be
turning on and off based on data from another column. When the criteria is
met, the formula writes the word "Start" in the cell. How do I write a
formula in the next column over so that if the word "Start" shows up in
Column 2, I want the next 5 rows down in Column 3 to have the word "Start"
too.

For example:
Column1 Column2 Column3
1 Start Start
2 Start
3 Start
4 Start
5 Start
6 etc......
7

I basically want my data to look like this:

Column5 Column 6 Column 7
1
2
3
4 Start On
5 On
6 On
7 On
8
9
10 Start On
11 On
12 On
13 On
14
15
16 Start

The word "Start" in column 6 is derived from the data in columns 1-5. Now
everytime the word "Start" appears in column 6 I would like the word "On" to
appear in Column 7 right beside it. I would also like the next three rows
immediately below in Column 7 to say "On" too. Even though the word "Start"
isn't beside them in Column 6. In other words when my machine runs, it has
to run for a minimum of four hours at a time. I hope that helps a bit. Any
help would be greatly appreciated.

Thanks.
Machineman



"Gord Dibben" wrote:

In C1 enter =IF($B$1="Start",$B$1,"")

Copy down to C5

If etc.... in C6 means something, please explain.


Gord Dibben MS Excel MVP

On Sun, 26 Nov 2006 12:04:02 -0800, Machineman
wrote:

Hello,

I have a formula in a column that determines when a machine should be
turning on and off based on data from another column. When the criteria is
met, the formula writes the word "Start" in the cell. How do I write a
formula in the next column over so that if the word "Start" shows up in
Column 2, I want the next 5 rows down in Column 3 to have the word "Start"
too.

For example:
Column1 Column2 Column3
1 Start Start
2 Start
3 Start
4 Start
5 Start
6 etc......
7

If "column 6" is column F and "column 7" is column G then try this formula in
G1 copied down

=IF(COUNTIF(INDEX(F:F,MAX(1,ROW()-3)):F1,"start"),"on","")

"Machineman" wrote:

I basically want my data to look like this:

Column5 Column 6 Column 7
1
2
3
4 Start On
5 On
6 On
7 On
8
9
10 Start On
11 On
12 On
13 On
14
15
16 Start

The word "Start" in column 6 is derived from the data in columns 1-5. Now
everytime the word "Start" appears in column 6 I would like the word "On" to
appear in Column 7 right beside it. I would also like the next three rows
immediately below in Column 7 to say "On" too. Even though the word "Start"
isn't beside them in Column 6. In other words when my machine runs, it has
to run for a minimum of four hours at a time. I hope that helps a bit. Any
help would be greatly appreciated.

Thanks.
Machineman



"Gord Dibben" wrote:

In C1 enter =IF($B$1="Start",$B$1,"")

Copy down to C5

If etc.... in C6 means something, please explain.


Gord Dibben MS Excel MVP

On Sun, 26 Nov 2006 12:04:02 -0800, Machineman
wrote:

Hello,

I have a formula in a column that determines when a machine should be
turning on and off based on data from another column. When the criteria is
met, the formula writes the word "Start" in the cell. How do I write a
formula in the next column over so that if the word "Start" shows up in
Column 2, I want the next 5 rows down in Column 3 to have the word "Start"
too.

For example:
Column1 Column2 Column3
1 Start Start
2 Start
3 Start
4 Start
5 Start
6 etc......
7

HOLY SMOKES!!!!!!!!!

Daddylonglegs, ur the greatest.....I've been trying to figure that out on my
own for over a day now. Thank you very much. Hopefully, I'll be able to
contribute to this forum too one day.

Thanks Again.


"daddylonglegs" wrote:

If "column 6" is column F and "column 7" is column G then try this formula in
G1 copied down

=IF(COUNTIF(INDEX(F:F,MAX(1,ROW()-3)):F1,"start"),"on","")

"Machineman" wrote:

I basically want my data to look like this:

Column5 Column 6 Column 7
1
2
3
4 Start On
5 On
6 On
7 On
8
9
10 Start On
11 On
12 On
13 On
14
15
16 Start

The word "Start" in column 6 is derived from the data in columns 1-5. Now
everytime the word "Start" appears in column 6 I would like the word "On" to
appear in Column 7 right beside it. I would also like the next three rows
immediately below in Column 7 to say "On" too. Even though the word "Start"
isn't beside them in Column 6. In other words when my machine runs, it has
to run for a minimum of four hours at a time. I hope that helps a bit. Any
help would be greatly appreciated.

Thanks.
Machineman



"Gord Dibben" wrote:

In C1 enter =IF($B$1="Start",$B$1,"")

Copy down to C5

If etc.... in C6 means something, please explain.


Gord Dibben MS Excel MVP

On Sun, 26 Nov 2006 12:04:02 -0800, Machineman
wrote:

Hello,

I have a formula in a column that determines when a machine should be
turning on and off based on data from another column. When the criteria is
met, the formula writes the word "Start" in the cell. How do I write a
formula in the next column over so that if the word "Start" shows up in
Column 2, I want the next 5 rows down in Column 3 to have the word "Start"
too.

For example:
Column1 Column2 Column3
1 Start Start
2 Start
3 Start
4 Start
5 Start
6 etc......
7

Thanks for the assist.

Machineman should be happy.

Gord

On Sun, 26 Nov 2006 14:47:02 -0800, daddylonglegs
wrote:

If "column 6" is column F and "column 7" is column G then try this formula in
G1 copied down

=IF(COUNTIF(INDEX(F:F,MAX(1,ROW()-3)):F1,"start"),"on","")

"Machineman" wrote:

I basically want my data to look like this:

Column5 Column 6 Column 7
1
2
3
4 Start On
5 On
6 On
7 On
8
9
10 Start On
11 On
12 On
13 On
14
15
16 Start

The word "Start" in column 6 is derived from the data in columns 1-5. Now
everytime the word "Start" appears in column 6 I would like the word "On" to
appear in Column 7 right beside it. I would also like the next three rows
immediately below in Column 7 to say "On" too. Even though the word "Start"
isn't beside them in Column 6. In other words when my machine runs, it has
to run for a minimum of four hours at a time. I hope that helps a bit. Any
help would be greatly appreciated.

Thanks.
Machineman



"Gord Dibben" wrote:

In C1 enter =IF($B$1="Start",$B$1,"")

Copy down to C5

If etc.... in C6 means something, please explain.


Gord Dibben MS Excel MVP

On Sun, 26 Nov 2006 12:04:02 -0800, Machineman
wrote:

Hello,

I have a formula in a column that determines when a machine should be
turning on and off based on data from another column. When the criteria is
met, the formula writes the word "Start" in the cell. How do I write a
formula in the next column over so that if the word "Start" shows up in
Column 2, I want the next 5 rows down in Column 3 to have the word "Start"
too.

For example:
Column1 Column2 Column3
1 Start Start
2 Start
3 Start
4 Start
5 Start
6 etc......
7



Gord Dibben MS Excel MVP