trough

  1. F

    Find location of shape

    Hi guys im trying to quickly find the row number of my shapes., they are added trough another macro. I had success with this code to find the location: For Each Shp In ActiveSheet.Shapes If Shp.Name = Application.Caller Then StartPos = Shp.TopLeftCell.Row Next Shp But can this...
  2. M

    Identify Peaks and Troughs in a Price Return

    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...
  3. R

    Identifying both cell references & values in peaks & troughs of a multi-wave data set

    I have a data set which is a recording of vertical ground reaction force during multiple hops. 30s long trial, 1000 Hz = 30,000 samples. For each wave, I need to identify: cell reference where value increases above a set threshold (e.g. >0.05 - marking the onset of the wave) peak value of...
  4. P

    Identifying peaks and troughs by analysing four columns.

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top