software

I would like to be able to copy formulas using something like quot;fill by
examplequot;.
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 quot;I
Agreequot; 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 quot;I Agreequot; in the message pane.

www.microsoft.com/office/comm...lic.excel.misc

=OFFSET(A$1,(ROW()-1)*3,0)

HTH
--
AP

quot;Paul Molesquot; gt; a écrit dans le message
de ...
gt; I would like to be able to copy formulas using something like quot;fill by
gt; examplequot;.
gt; a very simplified example would be
gt; B2 =A4, B3=A7, B4=A10 etc.
gt; I would like to be able to drag this series down column B.
gt;
gt;
gt; ----------------
gt; This post is a suggestion for Microsoft, and Microsoft responds to the
gt; suggestions with the most votes. To vote for this suggestion, click the quot;I
gt; Agreequot; button in the message pane. If you do not see the button, follow
this
gt; link to open the suggestion in the Microsoft Web-based Newsreader and then
gt; click quot;I Agreequot; in the message pane.
gt;
gt;
www.microsoft.com/office/comm...lic.excel.misc
Oooops!

in B2:
=OFFSET(A$2,(ROW()-1)*3,0)

--
AP

quot;Paul Molesquot; gt; a écrit dans le message
de ...
gt; I would like to be able to copy formulas using something like quot;fill by
gt; examplequot;.
gt; a very simplified example would be
gt; B2 =A4, B3=A7, B4=A10 etc.
gt; I would like to be able to drag this series down column B.
gt;
gt;
gt; ----------------
gt; This post is a suggestion for Microsoft, and Microsoft responds to the
gt; suggestions with the most votes. To vote for this suggestion, click the quot;I
gt; Agreequot; button in the message pane. If you do not see the button, follow
this
gt; link to open the suggestion in the Microsoft Web-based Newsreader and then
gt; click quot;I Agreequot; in the message pane.
gt;
gt;
www.microsoft.com/office/comm...lic.excel.misc
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: www.mvps.org/dmcritchie/excel/excel.htmquot;Ardus Petusquot; gt; wrote l...
gt; Oooops!
gt;
gt; in B2:
gt; =OFFSET(A$2,(ROW()-1)*3,0)
gt;
gt; --
gt; AP
gt;
gt; quot;Paul Molesquot; gt; a écrit dans le message
gt; gt; B2 =A4, B3=A7, B4=A10 etc.
gt; gt; I would like to be able to drag this series down column B.
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 quot;learnquot; and replicate
formulas given a couple/series of examples. Ended up posting a question
instead of suggestion.
Apologies and Thanks Paul

quot;David McRitchiequot; wrote:

gt; Hi Paul (and Ardus),
gt; The last suggestion was referring to the cell one down from what was asked, this would work
gt; B2: =OFFSET(A$4,(ROW(B2)-2)*3,0)
gt;
gt; BTW, you marked the original post as a suggestion to Microsoft, witnout a suggestion.
gt; and in fact asked a question instead.
gt; ---
gt; HTH,
gt; David McRitchie, Microsoft MVP - Excel
gt; My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
gt;
gt;
gt; quot;Ardus Petusquot; gt; wrote l...
gt; gt; Oooops!
gt; gt;
gt; gt; in B2:
gt; gt; =OFFSET(A$2,(ROW()-1)*3,0)
gt; gt;
gt; gt; --
gt; gt; AP
gt; gt;
gt; gt; quot;Paul Molesquot; gt; a écrit dans le message
gt; gt; gt; B2 =A4, B3=A7, B4=A10 etc.
gt; gt; gt; I would like to be able to drag this series down column B.
gt;
gt;
gt;