v8kid
|
| posted on 21/5/12 at 01:31 PM |
|
|
Tricky Excel help please
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!
You'd be surprised how quickly the sales people at B&Q try and assist you after ignoring you for the past 15 minutes when you try and start a
chainsaw
|
|
|
|
|
Slimy38
|
| posted on 21/5/12 at 01:59 PM |
|
|
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.
?
|
|
|
rachaeljf
|
| posted on 21/5/12 at 03:09 PM |
|
|
You say these are csv numbers, are they imported so that each number is in a separate cell?
|
|
|
bi22le
|
| posted on 21/5/12 at 06:04 PM |
|
|
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?
Track days ARE the best thing since sliced bread, until I get a supercharger that is!
Please read my ring story:
http://www.locostbuilders.co.uk/forum/13/viewthread.php?tid=139152&page=1
Me doing a sub 56sec lap around Brands Indy. I need a geo set up! http://www.youtube.com/watch?v=EHksfvIGB3I
|
|
|
v8kid
|
| posted on 21/5/12 at 06:30 PM |
|
|
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 
You'd be surprised how quickly the sales people at B&Q try and assist you after ignoring you for the past 15 minutes when you try and start a
chainsaw
|
|
|
rachaeljf
|
| posted on 22/5/12 at 11:56 AM |
|
|
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!
|
|
|
RIE
|
| posted on 30/5/12 at 07:48 PM |
|
|
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]
|
|
|
