IF function Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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","")
 
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.
 
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","")
Click to expand...

Gord Dibben MS Excel MVP
 
Back
Top