I know there should be an easy way to do this but I'm blessed if I can work it out.

I have a series of CSV numbers which contain a number of maxima and minima e.g.

12345654323456787654345 where 6&8 would be the maxima and 2&3 the minima

I need to find the Maxima numbers and show them in a column. Ditto for the minima.

after that I need to find the slope between adjacent maxima (ditto for minima).

I'm seeing double with nested If statements (and getting rubbish!) is there another way?

Cheers!

OK, this is about as messy as it gets, but it might work;

Column A contains the numbers
Columns B to (whatever) contains a split version of the number, so =mid(A1,1,1), =mid(A1,2,1) etc
The next columns then contain a max command, and again for the min command. (Not sure how you find the next maximum and minimum though?)
Then the next columns contains a subtraction between rows, so if the maximum are in column x for example, then =(x2-x1), =(x3-x2), etc.

?

You say these are csv numbers, are they imported so that each number is in a separate cell?

Is this CSV data generated by a track app?

If so, do you know that there is already free software out there to manipulate the data and give nice graphs for vid overlay?

Yup each no is imported into a seperate cell and sorry it's not a track app - its really geeky as I need to calculate n&k values for thin films using a different method than usually accepted.
Told you it was geeky

I've done a little spreadsheet that I think performs the operations you require. U2U if you want it!

Cheers R

Yes it's a quiet day at work!

To simplify things I'm going to assume a 3-cell range (A1:C1), each with one value in. If there is a maximum in the B1, then B1>A1 and B1>C1.

I would suggest this in the row below (starting in B2):

=IF(AND(B1>A1,B1>C1),B1,"")

And fill it across under the values in row one.

The reverse would work for minima in another row:

=IF(AND(B1<A1,B1<C1,),B1,"")

Probably a slicker way to do it, but that was just off the top of my head.

[Edited on 30/5/12 by RIE]