Finding max and min values for a sinusoidal wave

**throstur78** · 04-15-2009, 05:31 AM

Hi there,

my problem is the following;

I have data that has a sinusoidal shape over time, although not perfectly sinusoidal - It has some irregularites. In essence the values go up, reach a certain peak and then go down until they reach a certain negative value and then go up again. The peaks and min values varies over time.

Can get excel to find all of the peak values and minimum values for this sinusoidal-shaped wave?

regards,
Throstur

**franciz** · 04-15-2009, 05:34 AM

would you post a sample?

try the Max and Min functions for looking the maximum and minimum value in a range.

**throstur78** · 04-15-2009, 07:19 AM

Attached is a pdf file that shows how the data looks like and the values that I´m looking for. The sample I took is also attached in a spreadsheet.
Bear in mind that the data is much longer than what I post here. Please ask for any additional information about this if needed.

**Andy Pope** · 04-15-2009, 07:43 AM

You can use formula to test the adjacent points.

**istvan60** · 12-07-2013, 05:37 AM

This was of great help! Thanks Man!

**Shivalnt** · 06-18-2014, 05:29 AM

You are a genius. You saved great time for me. Thank you very much.

**infernojaffa** · 11-21-2014, 07:01 AM

Hi Andy

Are you able to advance your formula.

I have a similar multi-cycle wave although it jitters at min and max temperatures, this causes multiple readings per cycle. Is there anyway to fix this? i.e. determine all the values in the cycle and then doing MIN & MAX of these values?

I have attached an example of where this goes wrong.

Also is it then possible to grab these values and place themin another column (without the row breaks)?

Thanks
Andy

**Fotis1991** · 11-21-2014, 07:06 AM

Welcome to the forum.

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.