MrExcel Publishing
Your One Stop for Excel Tips & Solutions

How can I drag this way ?

Posted by GLITZ on March 04, 2001 1:25 PM

In column A I have the numbers 1 thru 10 listed vertically in rows 3 thru 11. In column C I want to have the numbers in A3:A11 to appear every three rows.

C3= A3
C6= A4
C9= A5
and so on...

Without using an array how can I do this?

Posted by Tim Francis-Wright on March 05, 2001 11:02 AM

I think that the following works: