Hi,
I am looking for a funcation in excel that will show my the Stationary points in th table. for exapmle
- A point is the lowest point on the table
- B point is the highest point - after point A
- C point is lowest point -after point B
.
- on the X there are point A,B and C,
- on the Y there are dates .
I hope it is clear - i diddn't find the way to add the excel.
I copy some of the excel table.
I marked 3 points point A is on the 2010.03.01 i marked the lowest point with A132.13A on row E point B on the 2010.03.17 i marked it B139.332B on raw D point C on the 2010.03.22 i marked it C134.533C raw E
2010.03.01 00:00 134.735 135.487 A132.13A 133.689
2010.03.02 00:00 133.687 133.74 132.46 132.773
2010.03.03 00:00 132.776 133.999 132.748 133.591
2010.03.04 00:00 133.59 134.811 132.554 133.883
2010.03.05 00:00 133.882 137.034 133.864 136.628
2010.03.08 00:00 136.94 137.339 135.658 135.888
2010.03.09 00:00 135.891 135.896 133.905 134.833
2010.03.10 00:00 134.831 135.88 133.899 135.593
2010.03.11 00:00 135.594 136.503 134.89 136.494
2010.03.12 00:00 136.489 138.052 136.069 137.648
2010.03.15 00:00 137.477 137.923 135.791 136.015
2010.03.16 00:00 136.017 137.813 135.162 137.562
2010.03.17 00:00 137.563 B139.332B 137.086 138.428
2010.03.18 00:00 138.423 138.543 137.01 137.959
2010.03.19 00:00 137.95 138.06 135.612 135.889
2010.03.22 00:00 135.605 136.183 C134.533C 136.079
2010.03.23 00:00 136.077 136.495 135.231 135.875
2010.03.24 00:00 135.876 137.399 135.482 137.108
2010.03.25 00:00 137.113 138.101 136.624 137.296
2010.03.26 00:00 137.295 138.012 137.037 137.776
2010.03.29 00:00 138.232 139.103 137.655 138.596
2010.03.30 00:00 138.59 140.526 137.998 139.803
2010.03.31 00:00 139.801 141.992 139.742 141.804
2010.04.01 00:00 141.805 142.334 141.727 142.033