If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
simple formula
Cell A4 = A1 + B3 Cell B4 = D1 + E3 C4 = G1 + H3 And so on. How can I write the formulat in A4 so that I can just drag that cell to cells B4, C4, D4 etc. so that it'll use the correct intervals of the other two rows? Can anyone help please thanks |
#2
|
|||
|
|||
simple formula
Hi
enter the following in A4 =OFFSET($A$1,0,(ROW()-4)*3)+OFFSET($B$3,0,(ROW()-4)*3) and copy down -- Regards Frank Kabel Frankfurt, Germany Ash T. wrote: Cell A4 = A1 + B3 Cell B4 = D1 + E3 C4 = G1 + H3 And so on. How can I write the formulat in A4 so that I can just drag that cell to cells B4, C4, D4 etc. so that it'll use the correct intervals of the other two rows? Can anyone help please thanks |
#3
|
|||
|
|||
simple formula
awesome,
Thank you so much Ash -----Original Message----- Hi enter the following in A4 =OFFSET($A$1,0,(ROW()-4)*3)+OFFSET($B$3,0,(ROW()-4)*3) and copy down -- Regards Frank Kabel Frankfurt, Germany Ash T. wrote: Cell A4 = A1 + B3 Cell B4 = D1 + E3 C4 = G1 + H3 And so on. How can I write the formulat in A4 so that I can just drag that cell to cells B4, C4, D4 etc. so that it'll use the correct intervals of the other two rows? Can anyone help please thanks . |
#4
|
|||
|
|||
simple formula
Sorry but it doesn't work.
-----Original Message----- Hi enter the following in A4 =OFFSET($A$1,0,(ROW()-4)*3)+OFFSET($B$3,0,(ROW()-4)*3) and copy down -- Regards Frank Kabel Frankfurt, Germany Ash T. wrote: Cell A4 = A1 + B3 Cell B4 = D1 + E3 C4 = G1 + H3 And so on. How can I write the formulat in A4 so that I can just drag that cell to cells B4, C4, D4 etc. so that it'll use the correct intervals of the other two rows? Can anyone help please thanks . |
#5
|
|||
|
|||
simple formula
ash,
Remember that everyone posting to this newsgroup works for free. They are very good at helping people, but you have to give them something to work with. What didn't work? What message did you get? What result did you get that was different from what you wanted? -- Regards, Fred Please reply to newsgroup, not e-mail "Ash" wrote in message ... Sorry but it doesn't work. -----Original Message----- Hi enter the following in A4 =OFFSET($A$1,0,(ROW()-4)*3)+OFFSET($B$3,0,(ROW()-4)*3) and copy down -- Regards Frank Kabel Frankfurt, Germany Ash T. wrote: Cell A4 = A1 + B3 Cell B4 = D1 + E3 C4 = G1 + H3 And so on. How can I write the formulat in A4 so that I can just drag that cell to cells B4, C4, D4 etc. so that it'll use the correct intervals of the other two rows? Can anyone help please thanks . |
#6
|
|||
|
|||
simple formula
Fred,
You sound like you are under the impression that I was blaming or was critical of the group. What gave you that impression? I'm not sure what is the connection between referring that everyone posting works for free. I have personnally thanked and expressed my appreciation many many times to everyone here. -----Original Message----- ash, Remember that everyone posting to this newsgroup works for free. They are very good at helping people, but you have to give them something to work with. What didn't work? What message did you get? What result did you get that was different from what you wanted? -- Regards, Fred Please reply to newsgroup, not e-mail "Ash" wrote in message ... Sorry but it doesn't work. -----Original Message----- Hi enter the following in A4 =OFFSET($A$1,0,(ROW()-4)*3)+OFFSET($B$3,0,(ROW()-4)*3) and copy down -- Regards Frank Kabel Frankfurt, Germany Ash T. wrote: Cell A4 = A1 + B3 Cell B4 = D1 + E3 C4 = G1 + H3 And so on. How can I write the formulat in A4 so that I can just drag that cell to cells B4, C4, D4 etc. so that it'll use the correct intervals of the other two rows? Can anyone help please thanks . . |
#7
|
|||
|
|||
simple formula
Hi
sorry my fault :-) I gave you a formula for dragging the formula down but not to the right :-) Try the following in A4: =OFFSET($A$1,0,(COLUMN()-1)*3)+OFFSET($B$3,0,(COLUMN()-1)*3) -- Regards Frank Kabel Frankfurt, Germany Ash wrote: Sorry but it doesn't work. -----Original Message----- Hi enter the following in A4 =OFFSET($A$1,0,(ROW()-4)*3)+OFFSET($B$3,0,(ROW()-4)*3) and copy down -- Regards Frank Kabel Frankfurt, Germany Ash T. wrote: Cell A4 = A1 + B3 Cell B4 = D1 + E3 C4 = G1 + H3 And so on. How can I write the formulat in A4 so that I can just drag that cell to cells B4, C4, D4 etc. so that it'll use the correct intervals of the other two rows? Can anyone help please thanks . |
#8
|
|||
|
|||
simple formula
Hi
I had no problem with your answer :-) But Fred mentioned one valid point: If a solution does not work it helps if you provide some detail what EXACTLY does not work. In this case not necessary as I just made a simple mistake :-) Solution: see my other posting -- Regards Frank Kabel Frankfurt, Germany Ash T. wrote: Fred, You sound like you are under the impression that I was blaming or was critical of the group. What gave you that impression? I'm not sure what is the connection between referring that everyone posting works for free. I have personnally thanked and expressed my appreciation many many times to everyone here. -----Original Message----- ash, Remember that everyone posting to this newsgroup works for free. They are very good at helping people, but you have to give them something to work with. What didn't work? What message did you get? What result did you get that was different from what you wanted? -- Regards, Fred Please reply to newsgroup, not e-mail "Ash" wrote in message ... Sorry but it doesn't work. -----Original Message----- Hi enter the following in A4 =OFFSET($A$1,0,(ROW()-4)*3)+OFFSET($B$3,0,(ROW()-4)*3) and copy down -- Regards Frank Kabel Frankfurt, Germany Ash T. wrote: Cell A4 = A1 + B3 Cell B4 = D1 + E3 C4 = G1 + H3 And so on. How can I write the formulat in A4 so that I can just drag that cell to cells B4, C4, D4 etc. so that it'll use the correct intervals of the other two rows? Can anyone help please thanks . . |
#9
|
|||
|
|||
simple formula
Frank,
Thank you very very much. I appreciate your help enormously. Now I can move on with this porject Cheers Ash -----Original Message----- Hi sorry my fault :-) I gave you a formula for dragging the formula down but not to the right :-) Try the following in A4: =OFFSET($A$1,0,(COLUMN()-1)*3)+OFFSET($B$3,0,(COLUMN()-1) *3) -- Regards Frank Kabel Frankfurt, Germany Ash wrote: Sorry but it doesn't work. -----Original Message----- Hi enter the following in A4 =OFFSET($A$1,0,(ROW()-4)*3)+OFFSET($B$3,0,(ROW()-4)*3) and copy down -- Regards Frank Kabel Frankfurt, Germany Ash T. wrote: Cell A4 = A1 + B3 Cell B4 = D1 + E3 C4 = G1 + H3 And so on. How can I write the formulat in A4 so that I can just drag that cell to cells B4, C4, D4 etc. so that it'll use the correct intervals of the other two rows? Can anyone help please thanks . . |
Thread Tools | |
Display Modes | |
|
|