Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
honour
 
Posts: n/a
Default autofill according to cell index.

for example I fill B1 cell with D3.And I want to fill the other B
cells(B2,B3...) with the D(3+n) .The n is a constant.For example n=2. That is
why B2=D5 or B3=D7.How can I do that??Thank you
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
in B1 enter
=OFFSET($D$3,(ROW()-1)*n,0)

--
Regards
Frank Kabel
Frankfurt, Germany

"honour" schrieb im Newsbeitrag
...
for example I fill B1 cell with D3.And I want to fill the other B
cells(B2,B3...) with the D(3+n) .The n is a constant.For example n=2.

That is
why B2=D5 or B3=D7.How can I do that??Thank you


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Display cell value on a chart. Andrew Constantinidis Charts and Charting in Excel 1 January 8th 05 04:36 AM
How do I set a cell to "Empty" so that it does not display in a ch Ian Charts and Charting in Excel 3 January 7th 05 01:12 AM
make a cell empty based on condition mpierre Charts and Charting in Excel 2 December 29th 04 01:01 PM
Cell value as chart scale maximum Phil Hageman Charts and Charting in Excel 9 December 17th 04 02:09 PM
Transferring cell content between workbooks using cell references Kiwi Mike Excel Discussion (Misc queries) 2 November 27th 04 11:31 PM


All times are GMT +1. The time now is 12:39 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"