| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
copy every 30th cell in the column into consecutive cells in anoth
Please help to find out how to copy every 30th cell in the column into
consecutive cells in another one. Thanks |
|
#2
|
|||
|
|||
|
With A1 as the starting cell as I understand you want 30 cells below so cell
A31 and then a61 and so on use =OFFSET($A$1,ROW()*30,0) on cell B1 and copy it down column B "shortcuts" wrote in message ... Please help to find out how to copy every 30th cell in the column into consecutive cells in another one. Thanks |
|
#3
|
|||
|
|||
|
shortcuts wrote:
Please help to find out how to copy every 30th cell in the column into consecutive cells in another one. Thanks Let A2:A1000 house the source data and C2 the first destination cell. In B2 enter & copy down: =INDEX($A$2:$A$1000,(ROW()-ROW(C$2))*3+1) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I copy a function for comparison but keep first cell value. | Excel Worksheet Functions | |||
| Can I copy a combo box in Excel 2002 with a relative cell link? | Excel Discussion (Misc queries) | |||
| Unable to Copy COUNTA() with cell references | Excel Worksheet Functions | |||
| Copy text from same cell on every sheet to title sheet? | Excel Discussion (Misc queries) | |||
| Copy formula to every 12th cell | Excel Worksheet Functions | |||
Hybrid Mode
