View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
RexAtHighSpeed
 
Posts: n/a
Default Rearrange two columns of data


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.


--
RexAtHighSpeed
------------------------------------------------------------------------
RexAtHighSpeed's Profile: http://www.excelforum.com/member.php...o&userid=29793
View this thread: http://www.excelforum.com/showthread...hreadid=494977