| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Increase Cell reference by 1 for every step
hi all
I have a series of numbers in column A2-A4240 and I need every second cell to appear in another table but I need it linked so that when the originals update so does the other table, however I haven't found a way to get every 2nd cell referenced, I put A2 and then A4 in the new table and copy it down but it jumps to A2 A4 A4 A6 A6 Is there any other way as I don't want to manually type them all in. Richard |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Increase Cell reference by 1 for every step
One way is to enter this in any column in Row 1
=INDIRECT("A"&ROW()*2) and copy down "akoobra" wrote: hi all I have a series of numbers in column A2-A4240 and I need every second cell to appear in another table but I need it linked so that when the originals update so does the other table, however I haven't found a way to get every 2nd cell referenced, I put A2 and then A4 in the new table and copy it down but it jumps to A2 A4 A4 A6 A6 Is there any other way as I don't want to manually type them all in. Richard |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Increase Cell reference by 1 for every step
Assume you want the results to appear starting in cell C2.
Enter this formula in C2 and copy down as needed: =INDEX(A$2:A$4240,ROWS(C$2:C2)*2-1) -- Biff Microsoft Excel MVP "akoobra" <akoobra@hotmail wrote in message ... hi all I have a series of numbers in column A2-A4240 and I need every second cell to appear in another table but I need it linked so that when the originals update so does the other table, however I haven't found a way to get every 2nd cell referenced, I put A2 and then A4 in the new table and copy it down but it jumps to A2 A4 A4 A6 A6 Is there any other way as I don't want to manually type them all in. Richard |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Increase Cell reference by 1 for every step
To create linked cells you could:
1. Enter the first two cell references preceded by "=: "=A2 "=A4 2, Select these two and drag down to fill the range . 3. Select the column and choose DataText to ColumnsFinish "akoobra" wrote: hi all I have a series of numbers in column A2-A4240 and I need every second cell to appear in another table but I need it linked so that when the originals update so does the other table, however I haven't found a way to get every 2nd cell referenced, I put A2 and then A4 in the new table and copy it down but it jumps to A2 A4 A4 A6 A6 Is there any other way as I don't want to manually type them all in. Richard |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating a Drop Down List with Step by Step Instructions for 2007 | Excel Worksheet Functions | |||
| HOW DO COPY A CELL BUT INCREASE ITS REFERENCE BY TWO CELL POSITIO. | Excel Discussion (Misc queries) | |||
| What is the step-by-step procedure for making a data list? | Excel Discussion (Misc queries) | |||
| I need step by step instructions to create a macro for 10 imbedde. | Excel Worksheet Functions | |||
| increase a cell reference by increments greater than one... | Excel Worksheet Functions | |||
Linear Mode
