How do I create a formula

[Guest]

I am trying to creat a formula to search my database by columns,

I have columns of numbers per hour such as:
Hr 1 2 3 4 5 6 7 8 9 10
11 12...
1/1/2002 100 235 200 215 300 320 300 210 177 150 130 110 ...
1/2/2002 102 210 190 102 77 65 21 100 105 102 125 275..


I have a value for each Hour of the day in the rows the days are lined down
the columns. i am trying to write a formula to return a signal value to the
user to let them know that if in that day the values per hour are a cycle. A
cycle for me is if the value drops 150 points with fours hours which would be
4 cells next to each other. Does anyone have a clue what I'm talking about?
Any help is appreciated

 

[Fredrik Wahlgren]

I am trying to creat a formula to search my database by columns,

I have columns of numbers per hour such as:
Hr 1 2 3 4 5 6 7 8 9 10
11 12...
1/1/2002 100 235 200 215 300 320 300 210 177 150 130 110 ...
1/2/2002 102 210 190 102 77 65 21 100 105 102 125 275..


I have a value for each Hour of the day in the rows the days are lined down
the columns. i am trying to write a formula to return a signal value to the
user to let them know that if in that day the values per hour are a cycle. A
cycle for me is if the value drops 150 points with fours hours which would be
4 cells next to each other. Does anyone have a clue what I'm talking about?
Any help is appreciated

Is your condition satisfied somewhere. Can you provide an example?

/Fredrik