=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!