| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| First significant figure | Excel Worksheet Functions | |||
| Validation length, Range length | Excel Discussion (Misc queries) | |||
| Determining error associated with polynomial trend lines. | Charts and Charting in Excel | |||
| Significant digits | Excel Worksheet Functions | |||
| Last significant row in a column | Excel Worksheet Functions | |||
Linear Mode
