Thread: how to write G1 in terms of B1+value in the cell 5 columns away (which is G1 itself))
View Single Post
 
Old 04-20-2012, 12:32 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 7 64bit Office 2010 64bit
Expert
  
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,920
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default
Quote:
Originally Posted by Sunny View Post

the sequence here is that from B1 to H1 to O1 to U1... are all 6 horizontal cells away each.
Between B and H there are 5 columns
between H and O there are 6 columns
between O and U there are 5 columns

If the 5 column interval is what you need, try
Code:
=INDIRECT(ADDRESS(1,(ROW()-1)*6+2))
in A1 and pull down as needed
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote