Hi,
Would anyone have an idea how to deal with this problem? It's a while since I last used VBA and what I am trying to do is essentially identifying local maxima of certain data points. That is:
1. I have a series of data in a Range (a column) in order. I would like to identify local maxima which means, if the value in current cell is greater than the value in the previous cell and the value in the cell after it, I want this value to be placed just in the same row but in the column next to it.
Otherwise, I want to leave the cell next to it empty and go to the next one.
I wrote a code but it fails to compile due to a "Type mismatch" problem and I can't figure out what it is.. :/
Thanks for all help!
Bookmarks