Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel copy formulas using non contiguous range
I would like to be able to copy formulas using something like "fill by
example". a very simplified example would be B2 =A4, B3=A7, B4=A10 etc. I would like to be able to drag this series down column B. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel copy formulas using non contiguous range
=OFFSET(A$1,(ROW()-1)*3,0)
HTH -- AP "Paul Moles" a écrit dans le message de ... I would like to be able to copy formulas using something like "fill by example". a very simplified example would be B2 =A4, B3=A7, B4=A10 etc. I would like to be able to drag this series down column B. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel copy formulas using non contiguous range
Oooops!
in B2: =OFFSET(A$2,(ROW()-1)*3,0) -- AP "Paul Moles" a écrit dans le message de ... I would like to be able to copy formulas using something like "fill by example". a very simplified example would be B2 =A4, B3=A7, B4=A10 etc. I would like to be able to drag this series down column B. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel copy formulas using non contiguous range
Hi Paul (and Ardus),
The last suggestion was referring to the cell one down from what was asked, this would work B2: =OFFSET(A$4,(ROW(B2)-2)*3,0) BTW, you marked the original post as a suggestion to Microsoft, witnout a suggestion. and in fact asked a question instead. --- HTH, David McRitchie, Microsoft MVP - Excel My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm "Ardus Petus" wrote l... Oooops! in B2: =OFFSET(A$2,(ROW()-1)*3,0) -- AP "Paul Moles" a écrit dans le message B2 =A4, B3=A7, B4=A10 etc. I would like to be able to drag this series down column B. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel copy formulas using non contiguous range
Thats where I went wrong.
The original formula was just a very simple example, I wanted to suggest that the next version of Excel needed the ability to "learn" and replicate formulas given a couple/series of examples. Ended up posting a question instead of suggestion. Apologies and Thanks Paul "David McRitchie" wrote: Hi Paul (and Ardus), The last suggestion was referring to the cell one down from what was asked, this would work B2: =OFFSET(A$4,(ROW(B2)-2)*3,0) BTW, you marked the original post as a suggestion to Microsoft, witnout a suggestion. and in fact asked a question instead. --- HTH, David McRitchie, Microsoft MVP - Excel My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm "Ardus Petus" wrote l... Oooops! in B2: =OFFSET(A$2,(ROW()-1)*3,0) -- AP "Paul Moles" a écrit dans le message B2 =A4, B3=A7, B4=A10 etc. I would like to be able to drag this series down column B. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mailing an excel range in the body of an e-mail | Excel Discussion (Misc queries) | |||
How do I name a range in Excel 2003? | Excel Discussion (Misc queries) | |||
copy & paste, a NEW CONCEPT (from Outlook to... Excel) | Excel Discussion (Misc queries) | |||
how to copy multiple Excel files from Outlook into Excel??? | Excel Discussion (Misc queries) | |||
copy worksheet to a new workbook with formulas .... but new file not point to old one | Excel Discussion (Misc queries) |