auto filling question

[vincent135]

how could i have something like this

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

[Miguel Zapico]

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

[vincent135]

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