 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / General Excel Questions / March 2008Massaging data to determine risk
In range of data I need to find jthe largest numerical movement in one direction without (x) retrace. (x in this case being a specific 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: In data the largest directional integer movement was 224 before the data moved 30 in reverse. Let's say your data is in column A, in B1 enter 0, in B2 enter: =IF(OR(B1=-1,A2<A1),-1,A2-A1) and copy down, In an un-used cell enter: =MAX(B:B) your desired answer. For example: 1 0 3 2 1 3 1 6 3 7 1 9 2 8 -1 12 -1 100 -1 114 -1 The maximum single step increase is 3 before the downturn.  SignatureGary''s Student - gsnu200776 > In range of data I need to find jthe largest numerical movement in one > direction without (x) retrace. (x in this case being a specific whole [quoted text clipped - 5 lines] > Example 2: In data the largest directional integer movement was 224 before > the data moved 30 in reverse. Gary, Thanks for the reply. However perhaps a bit of clarification is needed either by me or for you . You solved for the maximum single step increase before the downturn. I need to solve for the total increase or decrease before a fixed reversal. (data ? down/up before a reversal of x.) (for example x = 25) (200 points down before x) It is possible that the data would have multiple instances of x reversal, and I'd need to log each if possible. douglasjmorgans@yahoo.com > Let's say your data is in column A, in B1 enter 0, in B2 enter: > [quoted text clipped - 24 lines] > > Example 2: In data the largest directional integer movement was 224 before > > the data moved 30 in reverse.
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.