I have a list of numbers. for example:
1
2
3
4
5
6
4
2
1
0
3
4
5
Notice the numbers go from low to high, then go back down to low, then back up to high. The first high is 6, the low that follows it is 0, and the final high is 5.
Now, I have gazillions of data string, I just want to pick out the pivot points (meaning the highs or the lows). In other words, given the above string of numbers, the answer I want to derive at is simply 6,0 and 5. Do you know if I can do that via formulas?
Thanks in advance!!!
Bookmarks