auto filling question
 

how could i have something like this

=a11
=a11
=a11
=a12
=a12
=a12
=a13
=a13
=a13
=a14
=a14
=a14
....


--
vincent135
------------------------------------------------------------------------
vincent135's Profile: http://www.excelforum.com/member.php...o&userid=35373
View this thread: http://www.excelforum.com/showthread...hreadid=551469

auto filling question
 

You may use something like:
=INDIRECT("A" & 10 + INT(ROW()/3))
If you put this in row 3, it will return the value of cell A11 (10+3/3), and
dragging the formula down will follow the pattern that you wrote.
You can change the 10 + INT(ROW()/3) to make it fit your layout.

Hope this helps,
Miguel.

"vincent135" wrote:


how could i have something like this

=a11
=a11
=a11
=a12
=a12
=a12
=a13
=a13
=a13
=a14
=a14
=a14
....


--
vincent135
------------------------------------------------------------------------
vincent135's Profile: http://www.excelforum.com/member.php...o&userid=35373
View this thread: http://www.excelforum.com/showthread...hreadid=551469

auto filling question
 

thank you very much...it's is really helpful


--
vincent135
------------------------------------------------------------------------
vincent135's Profile: http://www.excelforum.com/member.php...o&userid=35373
View this thread: http://www.excelforum.com/showthread...hreadid=551469