Excel copy formulas using non contiguous range

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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/com...f-94e0e5ecd2f7&dg=microsoft.public.excel.misc
 
=OFFSET(A$1,(ROW()-1)*3,0)

HTH
--
AP

Paul Moles said:
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.
Click to expand...
http://www.microsoft.com/office/com...f-94e0e5ecd2f7&dg=microsoft.public.excel.misc
 
Oooops!

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

--
AP

Paul Moles said:
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.
Click to expand...
http://www.microsoft.com/office/com...f-94e0e5ecd2f7&dg=microsoft.public.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.
 
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
 
Back
Top