CODEWITHSUNDEEP
rexcelpot
Jamie Towner
Jamie Towner

Reputation: 1

Finding peaks in time series with duration condition

I was wondering if anybody could help. If I had a data set containing two columns of date and river flow, how could I obtain the top 100 largest values of river flow, with the condition of having at least a duration of XX days (e.g. 14 days) between each "peak" (i.e. two values which fall within two weeks of each other would only count as 1 peak).

Date Q
01/01/1990 24
02/01/1990 18
03/01/1990 40

I started by ranking all values and then picking out each peak and manually calculating if the next peak fell outside the 14 day period but I was wondering if this could be performed using a formula. Thanks.

Upvotes: 0

Views: 182

Answers (0)

Related Questions