auto filling question

V

vincent135

how could i have something like this

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

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