| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Formula Help
I have a spreadsheet where data is spread across Row 1:1.
I need a formula I can put in Cell A2 that will equal Cell A1. I then want to drag that formula down so that Cell A3 will equal Cell B1 and Cell A4 will equal Cell C1 and so. In Excel, when you drag formulas down, it wants to update the formula down. I need to drag the formula down, but for it to update the formula across. I hope I am wording this correctly. -- Thanks Shawn |
|
#2
|
|||
|
|||
|
Try...
A2, copied down: =OFFSET($A$1,0,ROW()-ROW($A$2)) Hope this helps! In article , "Shawn" wrote: I have a spreadsheet where data is spread across Row 1:1. I need a formula I can put in Cell A2 that will equal Cell A1. I then want to drag that formula down so that Cell A3 will equal Cell B1 and Cell A4 will equal Cell C1 and so. In Excel, when you drag formulas down, it wants to update the formula down. I need to drag the formula down, but for it to update the formula across. I hope I am wording this correctly. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
| Simplify formula | Excel Worksheet Functions | |||
| put formula results into a different cell if it is empty | Excel Worksheet Functions | |||
| how do i write a formula and keep in in formula form, so it DOESN. | Excel Discussion (Misc queries) | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Linear Mode
