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

"Daniel" wrote in message
...
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