Hi all,

Im a scientist (a clunky one at that) using excel to help analyse data. I have two columns 1. Date and 2. Flow in Megalitres, for the past 30 years for a river.

The data is 10,000+ rows, and i need to extract only the data where a decrease is occurring between values to perform my analysis.

e.g

01/01 100
02/01 90
03/01 80
04/01 70
05/01 75
06/01 80
07/01 70
08/01 60
09/01 80
10/11 90

From the example i'd want to extract the first 4 data points, and then the 6th,7th and 8th, omitting the rest!!!!

If anyone can help (in the name of science!) i'd be extremely appreciative as it would save hours, potentially days, of time.

Thankyou

Alex