AutoFIll -by dragging the bottom-right corner of the cell

[Guest]

Hi,
Take an Example:
the follwoing cells in an excel sheet contain the below values.
Cell E5 =1, cell F5=2
Cell E6 =3, cell F6=4
Cell E7 =5, cell F7=6
Cell E8 =7, cell F8=8


Now, select the row named: A10. write the formula as "=E5" Result is 1
select the row named: A11. write the formula as "=F5" Result is 2.

now select A10 & A11. Hold the mouse pointer at the bottom-right corner of
hte cell A11 and drag it to two or more cells.

I want the result to be

A12=E6
A13=F6
A14=E7
A15=F7
A16=E8
A17=F8

and so on...


Thanks in advance for your solutions
Venkatesh V

 

[Debra Dalgleish]

Enter the following formula in cell A10, and copy down:

=OFFSET($E$5,INT((ROW()-10)/2),MOD(ROW(),2))

 

[Guest]

Hi,
i tried the below solution which ui had give. It works only for that
cell. I htought this logic will work if implemented in any cells..

Here's the details of that.

Cell M3 & N3 contains some word. simillary in cell M4 & n4 ..upto the cells
M90 & N90.

I wanted the value of M3 in M100 and value of N3 in M101; value of M4 in
M102 & value of N4 in M103. and so on...

Thanks in Advance,
Venkat.

 

[Debra Dalgleish]

Change the cell reference, and the number subtracted from the row:

=OFFSET($M$3,INT((ROW()-100)/2),MOD(ROW(),2))

 

[Guest]

Hi,
Thanks for the reply.

I entered the formula in the cell M100 The. i dragged from the bottom-right
corner of the cell

The result is- the cell M100 shows the value of. M3. but, M101 doesnt show
the value of M4. Similarly, M102 shows the value of M5. but, M103 doesnt
show the value of M6 and so on...

Rgds,
Venkatesh V

 

[Debra Dalgleish]

No, it does what you asked for previously:

Hi,
Thanks for the reply.

I entered the formula in the cell M100 The. i dragged from the bottom-right
corner of the cell

The result is- the cell M100 shows the value of. M3. but, M101 doesnt show
the value of M4. Similarly, M102 shows the value of M5. but, M103 doesnt
show the value of M6 and so on...

Rgds,
Venkatesh V
: