IF function Question

[Machineman]

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]

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

 

[Machineman]

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

 

[daddylonglegs]

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]

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.

 

[Gord Dibben]

Thanks for the assist.

Machineman should be happy.

Gord

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","")

Gord Dibben MS Excel MVP