Hi everyone, I am making a template to analyze data that generates a curve (this is electrochemical data for a cyclovoltammogram, if that helps). There are several sweeps across the independent axis (potential in this case) both back and forth. I broke my data up into sweeps, so in each sweep (say from high to low potential), I would like to find the inflection point. My approach so far has been to graph the tangent at each point on the curve. I can find the maximum value (which is the inflection point), but I would like this template to find that maximum value and give me the corresponding point on the independent axis, which is in the adjacent cell to the right.
So in short, I want the cell next to the maximum value in an array. But note that this value next to the maximum is not the maximum value in that same column. If anyone can help me out with this I would greatly appreciate it. Thanks in advance!
It would probably help if you posted an example workbook
highlighting in some way the expected results.
Bookmarks