Determining length of trend before significant retrace
 

In range of data I need to find jthe largest numerical movement in one
direction without (x) retrace. (x in this case being a specified whole
number)
Please help with a formula or direct me to where I could find this
information.
Using Excel 2007
For example: in range of numerical data, the largest directional integer
movement was 300 before the data moved 25 in reverse.
Example 2: The largest directional integer movement was 224 before
the data moved 30 in reverse.

Determining length of trend before significant retrace
 

Assuming you have a column of numerical integer data in column B,
In C2, enter
=ABS(B2-B1)
to calculate the magnitude of the difference between them, then, in another
cell, enter
=LARGE(C2:C26,5)
where C2:C26 is your data range, and your looking for the 5th largest number.
--
Anne Murray


"DouglasinHawaii" wrote:

In range of data I need to find jthe largest numerical movement in one
direction without (x) retrace. (x in this case being a specified whole
number)
Please help with a formula or direct me to where I could find this
information.
Using Excel 2007
For example: in range of numerical data, the largest directional integer
movement was 300 before the data moved 25 in reverse.
Example 2: The largest directional integer movement was 224 before
the data moved 30 in reverse.