Hello,
I need help finding a way to copy down a column pattern. I will be creating list that starts in cell B7 and continues down for 200 rows. I'd like to be able to drag/copy down a column pattern. For example:
Cell B7 will refer to cell M99 (=M99)
Cell B8 will refer to cell AH99 (=AH99)
Cell B9 will refer to cell BC99 (=BC99)
Essentially, each cell is skipping ahead in column references by 21 columns. Can you help me figure out how best to do this? Thanks so much for the help!
Last edited by CR78; 05-12-2014 at 04:27 PM. Reason: typo
You'd get better results with an example file, but a combination of offset/match using row and column numbers sounds like the way to go.
Thanks so much for the reply. I'm not really sure how to use the offset/matching function you're referencing. Could you give me an example of how the formula would work? I can't upload the excel file I'm using as it includes some confidential information.Originally Posted by gak67
Should that first one have been M99?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Yes, sorry, I will correct this in my original post.
B7
=OFFSET($M$99,0,(ROWS($A$1:A1)-1)*21) copied down
or
=INDEX($99:$99,(ROWS($A$1:$A1)-1)*21+13)
Thanks so much ChemistB, I really appreciate the help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks