Formula
If I put a formula iin Cell A1 as follows = B1 and then drag that formula to
Cells A2 and A3 then the forumulas in those cells will be = B2 and = B3. Ok...but what if I want the A1 formula to be equal to B1 and A2 to be = to C1 and A3 to be equal to D1. I can't get the formula to drag in this fassion? -- Thanks Shawn |
Formula
one way:
A1: =INDEX($1:$1,ROW()+1) and copy down In article , "Shawn" wrote: If I put a formula iin Cell A1 as follows = B1 and then drag that formula to Cells A2 and A3 then the forumulas in those cells will be = B2 and = B3. Ok...but what if I want the A1 formula to be equal to B1 and A2 to be = to C1 and A3 to be equal to D1. I can't get the formula to drag in this fassion? |
All times are GMT +1. The time now is 11:24 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com