List

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!!!

Hi,

How are you wanting your results returned? For instance, do you want everything in a single cell - i.e. 6,0,5, etc. or do you want each value in a single cell - i.e.

6
0
5

I'm thinking you can probably do something with the LARGE and SMALL formulas, but need some clarification.

Cheers,

SamuelT