Hi. Need help please.
THANK YOU.
Burkie.
- I have a set of 100,000 CO2 readings, taken every 15 minutes from classrooms in a school.
- I am interested in the reading once it goes over 650 ( identified by the green in the attached extract )
- I need to identify the PEAK value WHILE it is WITHIN the 650 zone.
- There are a number of sub-peaks within the zone ( 5 in the extract I attached )
- So, I need a formula that knows its within the 650 zone and identifies the peak of the peaks and then resets when it leaves the 650 zone !
THANK YOU.
Burkie.