|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
how to write G1 in terms of B1+value in the cell 5 columns away (which is G1 itself))
for example
i want A1 to be = G1 (but i want to write G1 in terms of B1+value in the cell 5 columns away) and then A2 = G2 (but i want to write G2 in terms of B2+value in the cell 5 columns away) and then i will drag it down for many many rows thank you Last edited by Sunny; 04-19-2012 at 10:54 AM. Reason: i was mistaken |
#2
|
||||
|
||||
Could you provide a small example sheet please, I do not understand your query ?
__________________
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 |
#3
|
|||
|
|||
alright, here's the thing.
in column A in A1, the formula i put is =200*B1 in A2, the formula is =200*H1 in A3, =200*O1 A4, = 200*U1 the sequence here is that from B1 to H1 to O1 to U1... are all 6 horizontal cells away each. how to i do it? what formula do i put in column A Thank you |
#4
|
||||
|
||||
Quote:
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))
__________________
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 |
|
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 |