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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|