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