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? |
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? |
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 --- |
All times are GMT +1. The time now is 12:51 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com