I have data in a tab "New Schedule". In a different tab I would like to reference values in Column AG of "New Schedule". So starting in cell B26 I would like the value in cell AG66 of "New Schedule" to appear. In cell B36 I would like the value of cell AG67 of "New Schedule". I have tried to follow other examples but without any success. Can you help me with the correct formula?
Most people want to go the other way - that is, skip 10 rows in the source column for every row in the new sequence. This should work for you.
=INDEX('New Schedule'!$AG$66:$AG$88,INT((ROW()-26)/10)+1)
Change the $AG$88 to the end of your table.
Pauley
--------
If I helped with your issue, I'd appreciate a rep bump (hit the '*' icon to the bottom left of this post).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks