| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to transpose a list of reference cells without changing the li
There is a list of number under column A, and there is another list of number
under column B, which is refered to the value in column A, such as 3 [A1] =A1 [B1] 6 [A2] =A2 [B2] 4 [A3] =A3 [B3] .... 8 [A9] =A9 [B9] I would like to transpose column B startig from cell C1 without changing the link, =A1 [C1] =A2 [D1] =A3 [E1] .... =A9 [K1] Does anyone have any suggestions on how to do it? Thank in advance for any suggestions Eric |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing Cells from Relative to Absolute Reference | Excel Discussion (Misc queries) | |||
| Using Index to Transpose, Update Reference Cells as you Drag Down | Excel Worksheet Functions | |||
| VLOOKUP Changing reference cells in autofill | Excel Worksheet Functions | |||
| How to transpose a long list of text across cells | Excel Discussion (Misc queries) | |||
| Expanding conditional formating with reference cells changing | Excel Discussion (Misc queries) | |||
Threaded Mode
