peaks

I want to do formula for an average of L12W Sales without any outliers or peaks or bottom. What would the formula be? For example, here is last 12 weeks sales. I want it to average the sales in between 45-75 not taking 2,3,150,250 into the average. <tbody> 50 2 150 75 45 48 65 52 250 55 3 60...

Looking for excel formula(s) to identify major peaks and valleys. I've been using use slope combined with if, sign and vlookup to identify the peaks and troughs. My issue is there are too many peaks and troughs some of which occurring for consecutive y points. Is there a way to only show the...

Hello, I have a large set of data as a function of time, and I am trying to figure out the number of peaks in the data. However, there is some noise in the data that I would like the formula not to count as peaks by entering a certain threshold that the peaks must be above to be counted peaks...

Hi, I've done a lot of searching and I can't seem to find a macro to do what I need. I'm using Excel 2016 on a Windows7 system. I want to transfer the data from sheet1 to sheet2 but I need transfer the peaks into the correct peak# slots in Sheet2. My example Sheet1 includes a small portion...

Hi, I'm seeking a solution for conditionally counting the days between max values. In the example below, I'm trying to construct a conditional formula for the "DaysUnderPeak" column. This column would output the text "new peak" if the "Peak"(B) value is higher than the previous Date's(A) peak...

Hi, first time user, therefore apologies if i am re-posting that which has been posted before. I have the net cumulative total return daily series for the FTSE 100 and i am trying to write a formula that will calculate the peaks and troughs from start date to latest date. So my dates are in...

Hi, I'm working with a large data set with paired values. Simply, column A is the x value (time) paired with the neighboring y value (signal) in column B. I'm seeking to only retrieve the x-y pair (in columns G & H, respectively) when y >= a certain threshold for maxima and y <= for minima...

I have read a significant amount of the posts on peak and trough analysis in this forum, but still haven't identified a solution for my particular needs. I have a series of data where I would like to identify the newest high and relevant low reached between the new highs. I would then like to...

Hi, I am fairly new to Excel so would really appreciate some help with this problem. I am using Excel 2007 running on Vista. I have been trying to come up with a formula to determine peaks and troughs according to four conditions listed below. Here is a samlpe of a data set- Excel 2007...

Hi I have conducted a test measuring force over time (10 millisecond intervals) giving 5000 rows of results. The force peaks roughly every 200 rows and I want to display this in a table. If I just do a MAX (A1:A5000) I only get one maximum, if I do MAXA(A1:A5000,2) then the value is just the...