Hi
I'm wondering if there is an easy way of finding multiple max or min values (peaks) on a graph (data set)
Please see the attached image. I would like to know the value of each of the 10 peaks (marked with red dots) to average the value. I've got loads of graphs like this that needs the same averaging of peak values, and was just wondering if there is such a function in excel instead of looking through each data set and manually finding each of the 10 peak values.
Bookmarks