| Home |
| Search |
| Today's Posts |
|
#9
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 | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dragging a formula | Excel Discussion (Misc queries) | |||
| Dragging a formula | Excel Discussion (Misc queries) | |||
| I need help dragging a formula down | Excel Discussion (Misc queries) | |||
| dragging my formula | Excel Discussion (Misc queries) | |||
| Dragging Down a Formula | Excel Worksheet Functions | |||
Threaded Mode
