LinkBack URL
About LinkBacks
Hello. In K41:W41, I have references that start at K10 and go through W10. How can I copy this reference set down rows but have the references offset by 1 column for each row down. So, in K42:W42, I would I have L11:X11, and so on. Thanks.
Hello. In K41:W41, I have references that start at K10 and go through W10. How can I copy this reference set down rows but have the references offset by 1 column for each row down. So, in K42:W42, I would I have L11:X11, and so on. Thanks.
Try this formula:Let me know if you have any questions.
=INDIRECT(ADDRESS(ROW()-31,COLUMN()+ROW()-41))
Edit: Another way to do this that doesn't involve 'INDIRECT':Paste in K41 and drag down and across as necessary.=INDEX($K$10:$ZZ$40,ROW(A1),COLUMN(A1)-1+ROW(A1))
Last edited by JeteMc; 04-30-2016 at 08:07 AM. Reason: Added Edit
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks