Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advanced excel fill handle Question
In cells a1 is 1
in cell a2 is in cella3 is 3 etc.. How do you set up a fill in say column B such that when you use fill handle or equivalent b1 becomes equal to a1 but b2 becomes b3, b3 becomes b 5 the filling process to avoid every other line .. regards Pete G |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advanced excel fill handle Question
You could start by looking at the answer in your post of 17 minutes ago
"Pete G" wrote: In cells a1 is 1 in cell a2 is in cella3 is 3 etc.. How do you set up a fill in say column B such that when you use fill handle or equivalent b1 becomes equal to a1 but b2 becomes b3, b3 becomes b 5 the filling process to avoid every other line .. regards Pete G |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advanced excel fill handle Question
Ok, this is always fun, using the INDIRECT formula. But I have to warn you,
if you let this list go on too long your sheet may start to slow down. Anyway, the formula in B1 is: =A1 The formula in B2 is: =INDIRECT("A"&ROW()*2-1) Copy that formula down and it will collect the value from every other row in column A. -- "Actually, I AM a rocket scientist." -- JB Your feedback is appreciated, click YES if this post helped you. "Pete G" wrote: In cells a1 is 1 in cell a2 is in cella3 is 3 etc.. How do you set up a fill in say column B such that when you use fill handle or equivalent b1 becomes equal to a1 but b2 becomes b3, b3 becomes b 5 the filling process to avoid every other line .. regards Pete G |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel fill handle use -advanced | Excel Discussion (Misc queries) | |||
fill handle in Excel | Excel Worksheet Functions | |||
what is "fill handle". i don't see any fill handle in my excel | New Users to Excel | |||
Fill handle turned into a move handle | Excel Discussion (Misc queries) | |||
fill handle question | Excel Discussion (Misc queries) |