|
| 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
April 8th, 2009, 01:13 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
Dragging a formula
Dear,
I need to drag a simple reference formula =A7 in such a way that it follows a pattern. Something like... =a7 =a14 =a21 =a28 =a35 Can you please help me in doing this? 
|
|
#2
April 8th, 2009, 01:33 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Dragging a formula
Type A7 in the top cell
type A14 in the next cell Select both cells Drag down as far as you need Select the range Edit|replace what: A with: =A replace all Sasikiran wrote: Dear, I need to drag a simple reference formula =A7 in such a way that it follows a pattern. Something like... =a7 =a14 =a21 =a28 =a35 Can you please help me in doing this? -- Dave Peterson
|
|
#3
April 8th, 2009, 02:32 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Dragging a formula
Use this in B1 and copy down
=INDIRECT("A" & ROW()*7) ------------------------------------- Pl. click ''''Yes'''' if this was helpful... "Sasikiran" wrote: Dear, I need to drag a simple reference formula =A7 in such a way that it follows a pattern. Something like... =a7 =a14 =a21 =a28 =a35 Can you please help me in doing this?
|
|
#4
April 8th, 2009, 02:47 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Dragging a formula
Hello Sheelo,
Thank you for the revert. it's working absolutely fine in my below example... Actually i was looking for a formula which i can paste in the same row.... Like... =A747 in A1189 =A754 in A1190 Please help... "Sheeloo" wrote: Use this in B1 and copy down =INDIRECT("A" & ROW()*7) ------------------------------------- Pl. click ''''Yes'''' if this was helpful... "Sasikiran" wrote: Dear, I need to drag a simple reference formula =A7 in such a way that it follows a pattern. Something like... =a7 =a14 =a21 =a28 =a35 Can you please help me in doing this?
|
|
#5
April 8th, 2009, 02:55 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Dragging a formula
Correction....
Actually i was looking for a formula which i can paste in the same column.... Sorry for the same... "Sasikiran" wrote: Hello Sheelo, Thank you for the revert. it's working absolutely fine in my below example... Actually i was looking for a formula which i can paste in the same row.... Like... =A747 in A1189 =A754 in A1190 Please help... "Sheeloo" wrote: Use this in B1 and copy down =INDIRECT("A" & ROW()*7) ------------------------------------- Pl. click ''''Yes'''' if this was helpful... "Sasikiran" wrote: Dear, I need to drag a simple reference formula =A7 in such a way that it follows a pattern. Something like... =a7 =a14 =a21 =a28 =a35 Can you please help me in doing this?
|
|
#6
April 8th, 2009, 03:24 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Dragging a formula
Try this
=INDIRECT("A"&(COLUMN()-1)*7) in Col B and copy across Basically build a formula like (COLUMN()-1)*7 which gives you the number to append to the letter A to get the reference... This refers to A7 when entered in Col B If you want to start at, say A1189 then use =INDIRECT("A"&(1182+(COLUMN()-1)*7)) Row() and Column() give you the row number and column number of the cell containing the formula. ------------------------------------- Pl. click ''''Yes'''' if this was helpful... "Sasikiran" wrote: Correction.... Actually i was looking for a formula which i can paste in the same column.... Sorry for the same... "Sasikiran" wrote: Hello Sheelo, Thank you for the revert. it's working absolutely fine in my below example... Actually i was looking for a formula which i can paste in the same row.... Like... =A747 in A1189 =A754 in A1190 Please help... "Sheeloo" wrote: Use this in B1 and copy down =INDIRECT("A" & ROW()*7) ------------------------------------- Pl. click ''''Yes'''' if this was helpful... "Sasikiran" wrote: Dear, I need to drag a simple reference formula =A7 in such a way that it follows a pattern. Something like... =a7 =a14 =a21 =a28 =a35 Can you please help me in doing this?
|
|
#7
April 10th, 2009, 08:51 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Dragging a formula
Dear Sheeloo,
This formula is working fine when I'm trying to drag the formula to RIGHT in the same row. =INDIRECT("A"&(747+(COLUMN()-1)*7)) It is referring to A747 when inserted in A1189, and when it was dragged to RIGHT in the same row, in B1189 it was referring to A754 and so on... Actually i want to drag the formula to DOWN in the same column like... Referring A747 in A1189 A754 in A1190 A761 in A1191 I have tried all possibilities in the above formula but not able to get the desired result  Sorry for troubling you more... "Sheeloo" wrote: Try this =INDIRECT("A"&(COLUMN()-1)*7) in Col B and copy across Basically build a formula like (COLUMN()-1)*7 which gives you the number to append to the letter A to get the reference... This refers to A7 when entered in Col B If you want to start at, say A1189 then use =INDIRECT("A"&(1182+(COLUMN()-1)*7)) Row() and Column() give you the row number and column number of the cell containing the formula. ------------------------------------- Pl. click ''''Yes'''' if this was helpful... "Sasikiran" wrote: Correction.... Actually i was looking for a formula which i can paste in the same column.... Sorry for the same... "Sasikiran" wrote: Hello Sheelo, Thank you for the revert. it's working absolutely fine in my below example... Actually i was looking for a formula which i can paste in the same row.... Like... =A747 in A1189 =A754 in A1190 Please help... "Sheeloo" wrote: Use this in B1 and copy down =INDIRECT("A" & ROW()*7) ------------------------------------- Pl. click ''''Yes'''' if this was helpful... "Sasikiran" wrote: Dear, I need to drag a simple reference formula =A7 in such a way that it follows a pattern. Something like... =a7 =a14 =a21 =a28 =a35 Can you please help me in doing this?
|
|
#8
April 10th, 2009, 03:25 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Dragging a formula
Try this in A1189 and copy down Col A
=INDIRECT("A"&(747+(ROW()-1189)*7)) You have mentioned Actually i was looking for a formula which i can paste in the same row... Which means copy across in A1189 Like... =A747 in A1189 =A754 in A1190 Which is what this formula will do ------------------------------------- Pl. click ''''Yes'''' if this was helpful... "Sasikiran" wrote: Dear Sheeloo, This formula is working fine when I'm trying to drag the formula to RIGHT in the same row. =INDIRECT("A"&(747+(COLUMN()-1)*7)) It is referring to A747 when inserted in A1189, and when it was dragged to RIGHT in the same row, in B1189 it was referring to A754 and so on... Actually i want to drag the formula to DOWN in the same column like... Referring A747 in A1189 A754 in A1190 A761 in A1191 I have tried all possibilities in the above formula but not able to get the desired result Sorry for troubling you more... "Sheeloo" wrote: Try this =INDIRECT("A"&(COLUMN()-1)*7) in Col B and copy across Basically build a formula like (COLUMN()-1)*7 which gives you the number to append to the letter A to get the reference... This refers to A7 when entered in Col B If you want to start at, say A1189 then use =INDIRECT("A"&(1182+(COLUMN()-1)*7)) Row() and Column() give you the row number and column number of the cell containing the formula. ------------------------------------- Pl. click ''''Yes'''' if this was helpful... "Sasikiran" wrote: Correction.... Actually i was looking for a formula which i can paste in the same column.... Sorry for the same... "Sasikiran" wrote: Hello Sheelo, Thank you for the revert. it's working absolutely fine in my below example... Actually i was looking for a formula which i can paste in the same row.... Like... =A747 in A1189 =A754 in A1190 Please help... "Sheeloo" wrote: Use this in B1 and copy down =INDIRECT("A" & ROW()*7) ------------------------------------- Pl. click ''''Yes'''' if this was helpful... "Sasikiran" wrote: Dear, I need to drag a simple reference formula =A7 in such a way that it follows a pattern. Something like... =a7 =a14 =a21 =a28 =a35 Can you please help me in doing this?
|
|
#9
April 13th, 2009, 05:26 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Dragging a formula
Thanks a ton sheelo....
That was a great help.... "Sheeloo" wrote: Try this in A1189 and copy down Col A =INDIRECT("A"&(747+(ROW()-1189)*7)) You have mentioned Actually i was looking for a formula which i can paste in the same row... Which means copy across in A1189 Like... =A747 in A1189 =A754 in A1190 Which is what this formula will do ------------------------------------- Pl. click ''''Yes'''' if this was helpful... "Sasikiran" wrote: Dear Sheeloo, This formula is working fine when I'm trying to drag the formula to RIGHT in the same row. =INDIRECT("A"&(747+(COLUMN()-1)*7)) It is referring to A747 when inserted in A1189, and when it was dragged to RIGHT in the same row, in B1189 it was referring to A754 and so on... Actually i want to drag the formula to DOWN in the same column like... Referring A747 in A1189 A754 in A1190 A761 in A1191 I have tried all possibilities in the above formula but not able to get the desired result Sorry for troubling you more... "Sheeloo" wrote: Try this =INDIRECT("A"&(COLUMN()-1)*7) in Col B and copy across Basically build a formula like (COLUMN()-1)*7 which gives you the number to append to the letter A to get the reference... This refers to A7 when entered in Col B If you want to start at, say A1189 then use =INDIRECT("A"&(1182+(COLUMN()-1)*7)) Row() and Column() give you the row number and column number of the cell containing the formula. ------------------------------------- Pl. click ''''Yes'''' if this was helpful... "Sasikiran" wrote: Correction.... Actually i was looking for a formula which i can paste in the same column.... Sorry for the same... "Sasikiran" wrote: Hello Sheelo, Thank you for the revert. it's working absolutely fine in my below example... Actually i was looking for a formula which i can paste in the same row.... Like... =A747 in A1189 =A754 in A1190 Please help... "Sheeloo" wrote: Use this in B1 and copy down =INDIRECT("A" & ROW()*7) ------------------------------------- Pl. click ''''Yes'''' if this was helpful... "Sasikiran" wrote: Dear, I need to drag a simple reference formula =A7 in such a way that it follows a pattern. Something like... =a7 =a14 =a21 =a28 =a35 Can you please help me in doing this?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
