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

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

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

Venkatesh V wrote:
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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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" wrote:

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

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

Venkatesh V wrote:
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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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

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

Venkatesh V wrote:
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" wrote:


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

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

Venkatesh V wrote:

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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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" wrote:

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

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

Venkatesh V wrote:
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" wrote:


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

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

Venkatesh V wrote:

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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

No, it does what you asked for previously:

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...


Venkatesh V wrote:
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" wrote:


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

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

Venkatesh V wrote:

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" wrote:



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

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

Venkatesh V wrote:


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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html