| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Re-Arranging a Block of Data
=OFFSET(Sheet1!$A$1,MOD(ROW(),3),INT(ROW()/3))
the offset has to start somewhere and you cant up or left from a1 :) row counts are 1 based, so I should have made a small adjustment =OFFSET(Sheet1!$A$1;MOD(ROW()-1;3);INT((ROW()-1)/3)) cheerz! keepITcool < email : keepitcool chello nl (with @ and .) < homepage: http://members.chello.nl/keepitcool Mark Roach wrote: Thanks. That is so simple and cool. You don't have to understand gravity to enjoy it! I would like to know why the formula doesn't return the contents of cell A1. It looks like it starts with A2. Mark Roach Technical Resources Manager The Oil & Gas Asset Clearinghouse Houston, Texas *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Arranging a data in required format | Excel Discussion (Misc queries) | |||
| re-arranging the data | Excel Discussion (Misc queries) | |||
| Help Arranging Data on Spreadsheet | Excel Discussion (Misc queries) | |||
| Arranging Excel Data | Excel Discussion (Misc queries) | |||
| ARRANGING DATA IN PIVOT TABLES | Excel Worksheet Functions | |||
Threaded Mode
