Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel novice question on filling in missing fields/cells | Excel Discussion (Misc queries) | |||
Auto Filter Question? | Excel Discussion (Misc queries) | |||
Running auto correct on startup? | Excel Discussion (Misc queries) | |||
Excel atuo filling cells- question | Excel Discussion (Misc queries) | |||
Auto Filter Limit Question | Excel Discussion (Misc queries) |