Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pick cells on the diagonal
I would like to copy cells in an excel worksheet following this pattern: e.g.
A1, F3, K4 etc. Is it possible to mark the cells and then copy them all at a time? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pick cells on the diagonal
If your intent is to extract the diagonal cells into a continuous col range
eg: A1, F3, K5 ... (you probably had a typo in your post: "K4") here's one way which makes it a breeze, and dynamic, too ... Assume your source data is in Sheet1 In another sheet, in any startcell, say in B2: =OFFSET(Sheet1!$A$1,ROWS($1:1)*2-2,ROWS($1:1)*5-5) Copy down as far as required to extract as required Adapt easily to suit: Sheet1!$A$1 is the top left cell in the source sheet The ROWS bits of it in the expression is aligned to the down 2x1, across 5x1, then down 2x2, across 5x5, etc, ie the zigzag path that defines the diagonal cells A1, F3, K5 ... Success? Immortalize this response, zonk the YES below -- Max Singapore --- "A." wrote: I would like to copy cells in an excel worksheet following this pattern: e.g. A1, F3, K4 etc. Is it possible to mark the cells and then copy them all at a time? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pick cells on the diagonal
My typo, this part:
.. then down 2x2, across 5x5, etc should read: then down 2x2, across 5x2, etc -- Max Singapore --- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need diagonal lines behind printed cells. | Excel Discussion (Misc queries) | |||
Adding pick calendars to cells | Excel Discussion (Misc queries) | |||
pick up cells | Excel Discussion (Misc queries) | |||
Creating cells with Diagonal borders | Excel Discussion (Misc queries) | |||
Is there a way to pick the cells to add using sum? | Excel Worksheet Functions |