LinkBack URL
About LinkBacks
='Work Codes'!AC1998
Is it possible to copy this formula down making the next entry:
='Work Codes'!AD1998
The data on the work code page is horizontal. The data also comes from a formula on the work code page meaning I cannot copy and transpose.
='Work Codes'!AC1998
Is it possible to copy this formula down making the next entry:
='Work Codes'!AD1998
The data on the work code page is horizontal. The data also comes from a formula on the work code page meaning I cannot copy and transpose.
Last edited by jcranst; 09-10-2012 at 10:45 AM.
Let's say your data runs from AD1998 to BA1998
You can use
=INDEX($AD$1998:$BA$1998),ROW(A1))
Does that work for you?
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
What does the ROW(a1) spot in the formula mean?
Thanks
Last edited by jcranst; 09-10-2012 at 11:17 AM.
row(a1) retuns a value of 1 then as its dragged down inceses row(a2) =2 row (a3) =3 etc
The Importance of INDEX - A GUIDE TO INDEX'S OTHER USES
<--- If a post helps hit the star
Got it to work. Thanks Very Much.
remeber to mark it solved and star tap those that help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks