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

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

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

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.

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.