how to write G1 in terms of B1+value in the cell 5 columns away (which is G1 itself))

		Microsoft Office Forums > Microsoft Excel > Excel
how to write G1 in terms of B1+value in the cell 5 columns away (which is G1 itself))

FAQ

Thread Tools

Display Modes

04-20-2012, 12:32 AM

Pecoflyer

Windows 7 64bit how to write G1 in terms of B1+value in the cell 5 columns away (which is G1 itself))

Office 2010 64bit

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,955

Pecoflyer has a reputation beyond repute

Quote:

Originally Posted by Sunny

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

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Need macro to make list of "defined terms"	glnz	Word VBA	8	09-07-2022 02:09 PM
How can I write the following (whole) formula in a single cell?	Learner7	Excel	1	07-19-2010 10:06 AM
How to compare 2 columns with other two columns in EXECL 2007?	Learner7	Excel	5	06-12-2010 09:54 AM
I am trying to discover how to write a comm. Add-in	patc4	Office	1	06-16-2009 11:11 AM
terms of use	heidi	Misc	0	01-15-2007 03:01 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:23 PM.