| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
| Text to Columns / Importing Data | Excel Discussion (Misc queries) | |||
| How do i copy columns of data in notepad into microsoft excel? | Excel Discussion (Misc queries) | |||
| How do i copy columns of data in notepad into microsoft excel? | Excel Discussion (Misc queries) | |||
| Rearrange data columns in Pivot Table | Excel Discussion (Misc queries) | |||
Threaded Mode
