I have three columns of data. Column A is numbered from 0 to 720. Column B and C are measured data that I need to shift up or down relative to Column A. I want the peak value in Column B to line up with a user-specified value in Column A. If I specify 360, I want the peak value in Column B to line up with 360 on Column A. If I specify 359, I want the peak value to line up with 359. However, the data in Column B and C cannot be sorted or rearranged. The entire range of values must be shifted up or down.
How can I do it?
I tried searching but found nothing like what I'm trying to do.
Bookmarks