| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copying cells at a specific interval
Hello,
I have a row of 12 000 cells, but i want to use just every 4th cell, for example: A1 A2 A3 A4 A5 A6 A7 A8 A9 A10 A11 A12 A13 form that row i need just need A1, A4, A8, A12 How can i copy every 4th cell into another row? Or whatever solution to the problem you offer could you help me with this? Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
copying cells at a specific interval
could someone help me with this, please?
|
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
copying cells at a specific interval
in B1
=indirect("A"&row($A1)*4) drag fill down the column In your example, A1 is omitted - it is not every 4th cell. -- Regards, Tom Ogilvy "ANton Petrov" wrote in message ... could someone help me with this, please? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2002: Any button to insert blank rows at specific interval? | Excel Discussion (Misc queries) | |||
| How do you create a series based on a specific interval? | Excel Discussion (Misc queries) | |||
| Copying records from a date interval from one worksheet to another | Excel Discussion (Misc queries) | |||
| Copying specific cells from a sheet to another | Excel Discussion (Misc queries) | |||
| Specific keywords copying data to cells | Excel Worksheet Functions | |||
Linear Mode
