Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display cell value on a chart. | Charts and Charting in Excel | |||
How do I set a cell to "Empty" so that it does not display in a ch | Charts and Charting in Excel | |||
make a cell empty based on condition | Charts and Charting in Excel | |||
Cell value as chart scale maximum | Charts and Charting in Excel | |||
Transferring cell content between workbooks using cell references | Excel Discussion (Misc queries) |