GWee
New Member
- Joined
- Nov 8, 2005
- Messages
- 24
The formula I'm using is: =INDEX(Sheet1!A:A,2)
The formula is in: Sheet2 A2
I need to repeat the formula down 800 rows.
Automatic Calculation is On.
I selected the A2 cell and clicked and hold the crossbar on right bottom corner and dragged......doesn't calculate down, just copies the A2 cell.
If you take out one parenthesis and the = to test,.....it works! I noticed that formulas with parenthesis don't calculate down, they just copy.
All my formulas calculate down just fine if I don't use parenthesis...that's a bummer.
Does anybody have a fix?
The formula is in: Sheet2 A2
I need to repeat the formula down 800 rows.
Automatic Calculation is On.
I selected the A2 cell and clicked and hold the crossbar on right bottom corner and dragged......doesn't calculate down, just copies the A2 cell.
If you take out one parenthesis and the = to test,.....it works! I noticed that formulas with parenthesis don't calculate down, they just copy.
All my formulas calculate down just fine if I don't use parenthesis...that's a bummer.
Does anybody have a fix?