dbcooper88
New Member
- Joined
- Dec 3, 2016
- Messages
- 36
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 major peaks and troughs thus eliminating so many peaks and troughs for noisy data? TIA
A B
1 4
5 1
8 3
14 6
17 7
22 6
33 3
A B
1 4
5 1
8 3
14 6
17 7
22 6
33 3