|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
June 2nd, 2004, 05:38 PM
|
|||
|
|||
copying non-sequential cell references
I've always wondered if this is popssible and it would
help greatly. I need to copy the contents of every thirteenth cell in column A to consecutive cells in column B, so A13 copies to B1, A26 to B2, and so on. Is there a quick way to write the formula for the cells in column B? It will take forever to write the formula for each B cell (200 of them!) individually. Many thanks Gary 
|
|
#2
June 2nd, 2004, 06:19 PM
|
|||
|
|||
|
copying non-sequential cell references
Copy this formula in B1 and copy it down
=INDIRECT("A" & ROW()*13) -- Regards Ron de Bruin http://www.rondebruin.nl wrote in message ... I've always wondered if this is popssible and it would help greatly. I need to copy the contents of every thirteenth cell in column A to consecutive cells in column B, so A13 copies to B1, A26 to B2, and so on. Is there a quick way to write the formula for the cells in column B? It will take forever to write the formula for each B cell (200 of them!) individually. Many thanks Gary
|
|
#3
June 2nd, 2004, 06:41 PM
|
|||
|
|||
|
copying non-sequential cell references
I don't understand it, but it works great. Thanks very
much. -----Original Message----- Copy this formula in B1 and copy it down =INDIRECT("A" & ROW()*13) -- Regards Ron de Bruin http://www.rondebruin.nl wrote in message ... I've always wondered if this is popssible and it would help greatly. I need to copy the contents of every thirteenth cell in column A to consecutive cells in column B, so A13 copies to B1, A26 to B2, and so on. Is there a quick way to write the formula for the cells in column B? It will take forever to write the formula for each B cell (200 of them!) individually. Many thanks Gary .
|
|
#4
June 2nd, 2004, 06:51 PM
|
|||
|
|||
|
copying non-sequential cell references
Hi
=INDIRECT("A" & ROW()*13) ROW() give you the row number of the cell The formula in B3 for example will display the value of "A" & 3*13 = 39 A39 -- Regards Ron de Bruin http://www.rondebruin.nl wrote in message ... I don't understand it, but it works great. Thanks very much. -----Original Message----- Copy this formula in B1 and copy it down =INDIRECT("A" & ROW()*13) -- Regards Ron de Bruin http://www.rondebruin.nl wrote in message ... I've always wondered if this is popssible and it would help greatly. I need to copy the contents of every thirteenth cell in column A to consecutive cells in column B, so A13 copies to B1, A26 to B2, and so on. Is there a quick way to write the formula for the cells in column B? It will take forever to write the formula for each B cell (200 of them!) individually. Many thanks Gary .
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
