Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Complex Autofill does not follow formula
I have a spread sheet - row 3 is a progression from 3-20 (3,4,5....19,20)
Column C has set values starting from row 6. E6=E4*C6 E7=E4*E4*C7 E8=E*E4*E4*C8 E8=E4*E4*E4*E4*C9 F6=F4*C6 F7=F4*F4*C7 F8=F4*F4*F4*C8 F9=F4*F4*F4*F4*C9 if I use autofill by dragging across to fill columns G onwards the C7 becomes E7 then F7 thenG7 and so on, eg G8=G4*G4*G4*E8 instead of the correct G4*G4*G4*C8 - same problem if I drag down - E10 becomes =E8*C10 instead of =F4*F4*F4*F4*F4*C10. All help gratefull received as I have have to extend this table in both directions. OS is XP Home - excel is 2002 Many Thanks -- When would now be a good time to change? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Complex Autofill does not follow formula
=$E$4^ROW(A1)*$C6
and so on -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "The Life Coach" wrote in message ... I have a spread sheet - row 3 is a progression from 3-20 (3,4,5....19,20) Column C has set values starting from row 6. E6=E4*C6 E7=E4*E4*C7 E8=E*E4*E4*C8 E8=E4*E4*E4*E4*C9 F6=F4*C6 F7=F4*F4*C7 F8=F4*F4*F4*C8 F9=F4*F4*F4*F4*C9 if I use autofill by dragging across to fill columns G onwards the C7 becomes E7 then F7 thenG7 and so on, eg G8=G4*G4*G4*E8 instead of the correct G4*G4*G4*C8 - same problem if I drag down - E10 becomes =E8*C10 instead of =F4*F4*F4*F4*F4*C10. All help gratefull received as I have have to extend this table in both directions. OS is XP Home - excel is 2002 Many Thanks -- When would now be a good time to change? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Complex Autofill does not follow formula
Dear Bob,
many thanks - could you expand on that a bit please - I assume you mean i repce my existing formulas with a variant on your suggestion - how would they look for say cells E6,E7,F6&F7. Many thanks again Andy Smulian -- When would now be a good time to change? "Bob Phillips" wrote: =$E$4^ROW(A1)*$C6 and so on -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "The Life Coach" wrote in message ... I have a spread sheet - row 3 is a progression from 3-20 (3,4,5....19,20) Column C has set values starting from row 6. E6=E4*C6 E7=E4*E4*C7 E8=E*E4*E4*C8 E8=E4*E4*E4*E4*C9 F6=F4*C6 F7=F4*F4*C7 F8=F4*F4*F4*C8 F9=F4*F4*F4*F4*C9 if I use autofill by dragging across to fill columns G onwards the C7 becomes E7 then F7 thenG7 and so on, eg G8=G4*G4*G4*E8 instead of the correct G4*G4*G4*C8 - same problem if I drag down - E10 becomes =E8*C10 instead of =F4*F4*F4*F4*F4*C10. All help gratefull received as I have have to extend this table in both directions. OS is XP Home - excel is 2002 Many Thanks -- When would now be a good time to change? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Complex Autofill does not follow formula
If you put this slightly modified version in E6
=E$4^ROW($A1)*$C6 you should be able to drag it across and down and get what you want -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "The Life Coach" wrote in message ... Dear Bob, many thanks - could you expand on that a bit please - I assume you mean i repce my existing formulas with a variant on your suggestion - how would they look for say cells E6,E7,F6&F7. Many thanks again Andy Smulian -- When would now be a good time to change? "Bob Phillips" wrote: =$E$4^ROW(A1)*$C6 and so on -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "The Life Coach" wrote in message ... I have a spread sheet - row 3 is a progression from 3-20 (3,4,5....19,20) Column C has set values starting from row 6. E6=E4*C6 E7=E4*E4*C7 E8=E*E4*E4*C8 E8=E4*E4*E4*E4*C9 F6=F4*C6 F7=F4*F4*C7 F8=F4*F4*F4*C8 F9=F4*F4*F4*F4*C9 if I use autofill by dragging across to fill columns G onwards the C7 becomes E7 then F7 thenG7 and so on, eg G8=G4*G4*G4*E8 instead of the correct G4*G4*G4*C8 - same problem if I drag down - E10 becomes =E8*C10 instead of =F4*F4*F4*F4*F4*C10. All help gratefull received as I have have to extend this table in both directions. OS is XP Home - excel is 2002 Many Thanks -- When would now be a good time to change? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Complex Autofill does not follow formula
Bob,
A huge thank you - I'll look up those symbols and learn how to use them for myself now - again - many many thanks. -- When would now be a good time to change? "Bob Phillips" wrote: If you put this slightly modified version in E6 =E$4^ROW($A1)*$C6 you should be able to drag it across and down and get what you want -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "The Life Coach" wrote in message ... Dear Bob, many thanks - could you expand on that a bit please - I assume you mean i repce my existing formulas with a variant on your suggestion - how would they look for say cells E6,E7,F6&F7. Many thanks again Andy Smulian -- When would now be a good time to change? "Bob Phillips" wrote: =$E$4^ROW(A1)*$C6 and so on -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "The Life Coach" wrote in message ... I have a spread sheet - row 3 is a progression from 3-20 (3,4,5....19,20) Column C has set values starting from row 6. E6=E4*C6 E7=E4*E4*C7 E8=E*E4*E4*C8 E8=E4*E4*E4*E4*C9 F6=F4*C6 F7=F4*F4*C7 F8=F4*F4*F4*C8 F9=F4*F4*F4*F4*C9 if I use autofill by dragging across to fill columns G onwards the C7 becomes E7 then F7 thenG7 and so on, eg G8=G4*G4*G4*E8 instead of the correct G4*G4*G4*C8 - same problem if I drag down - E10 becomes =E8*C10 instead of =F4*F4*F4*F4*F4*C10. All help gratefull received as I have have to extend this table in both directions. OS is XP Home - excel is 2002 Many Thanks -- When would now be a good time to change? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Locking in Formula cell to follow its cells that contain calc data | Excel Discussion (Misc queries) | |||
HOW DO I LINK PAGES ON EXCEL TO FOLLOW SAME LINKED FORMULA? | Excel Worksheet Functions | |||
Autofill formula to next row | Excel Discussion (Misc queries) | |||
Inserting rows and having the formula follow | New Users to Excel | |||
Autofill: Need to autofill one week block, (5) weekday only into cells. | Excel Discussion (Misc queries) |