| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula won't change correctly when dragged
In Excel 2003:
I have this formula: ='5West'!F33 and I want to drag it down to the cell below this one and have the column reference ("F") change but not the row reference ("33") so the new formula would be: ='5West'!G33. But instead it changed the number and not the letter. If I make the formula: ='5West'!F$33, then it drags the formula down as is and still doesn't change the letter. How can I make it change the letter? Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula won't change correctly when dragged
Assume you want the formulas entered starting in cell A1...
=INDEX('5West'!F$33:J$33,ROWS(A$1:A1)) Change J$33 to reflect the actual end of the range you're using. -- Biff Microsoft Excel MVP "Meenie" wrote in message ... In Excel 2003: I have this formula: ='5West'!F33 and I want to drag it down to the cell below this one and have the column reference ("F") change but not the row reference ("33") so the new formula would be: ='5West'!G33. But instead it changed the number and not the letter. If I make the formula: ='5West'!F$33, then it drags the formula down as is and still doesn't change the letter. How can I make it change the letter? Thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula won't change correctly when dragged
Wow, that works perfectly... now... is there a way to be able to drag it
across the rows so it does the same thing without changing the F...:J...? (I know, I don't want much!) "T. Valko" wrote: Assume you want the formulas entered starting in cell A1... =INDEX('5West'!F$33:J$33,ROWS(A$1:A1)) Change J$33 to reflect the actual end of the range you're using. -- Biff Microsoft Excel MVP "Meenie" wrote in message ... In Excel 2003: I have this formula: ='5West'!F33 and I want to drag it down to the cell below this one and have the column reference ("F") change but not the row reference ("33") so the new formula would be: ='5West'!G33. But instead it changed the number and not the letter. If I make the formula: ='5West'!F$33, then it drags the formula down as is and still doesn't change the letter. How can I make it change the letter? Thanks |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula won't change correctly when dragged
OOO never mind I figured it out!!!!!!!! Thanks bunches!
"T. Valko" wrote: Assume you want the formulas entered starting in cell A1... =INDEX('5West'!F$33:J$33,ROWS(A$1:A1)) Change J$33 to reflect the actual end of the range you're using. -- Biff Microsoft Excel MVP "Meenie" wrote in message ... In Excel 2003: I have this formula: ='5West'!F33 and I want to drag it down to the cell below this one and have the column reference ("F") change but not the row reference ("33") so the new formula would be: ='5West'!G33. But instead it changed the number and not the letter. If I make the formula: ='5West'!F$33, then it drags the formula down as is and still doesn't change the letter. How can I make it change the letter? Thanks |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula won't change correctly when dragged
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "Meenie" wrote in message ... OOO never mind I figured it out!!!!!!!! Thanks bunches! "T. Valko" wrote: Assume you want the formulas entered starting in cell A1... =INDEX('5West'!F$33:J$33,ROWS(A$1:A1)) Change J$33 to reflect the actual end of the range you're using. -- Biff Microsoft Excel MVP "Meenie" wrote in message ... In Excel 2003: I have this formula: ='5West'!F33 and I want to drag it down to the cell below this one and have the column reference ("F") change but not the row reference ("33") so the new formula would be: ='5West'!G33. But instead it changed the number and not the letter. If I make the formula: ='5West'!F$33, then it drags the formula down as is and still doesn't change the letter. How can I make it change the letter? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| replace a number in a sentence every time it is dragged | Excel Worksheet Functions | |||
| Locking Clolumn Color So It Won't Get Dragged Away | Excel Discussion (Misc queries) | |||
| Formula not changing when Dragged!!!! | Excel Discussion (Misc queries) | |||
| How do I keep text viewing correctly as I change zoom % | Excel Discussion (Misc queries) | |||
| Indirect reference to another sheet that can be dragged | Excel Worksheet Functions | |||
Linear Mode
