Autofill issue
I am trying to autofill a formula. I am in cell A12. Assuming that I want
to multiply A10*J1. When I autofill it across, I would like the A10 to change to A11, A12, etc. However, I want the J1 to change to J2, J3, etc. Absolutes will not work. I'm sure that this isn't simple multiplication. Does anyone have a function that will do this? Thanks. |
Autofill issue
hi,
Try this in a12 and drag right =INDIRECT("A"&COLUMN(J10))*INDIRECT("J"&COLUMN(A1) ) Mike "Jean" wrote: I am trying to autofill a formula. I am in cell A12. Assuming that I want to multiply A10*J1. When I autofill it across, I would like the A10 to change to A11, A12, etc. However, I want the J1 to change to J2, J3, etc. Absolutes will not work. I'm sure that this isn't simple multiplication. Does anyone have a function that will do this? Thanks. |
Autofill issue
In A12
=A10*J1 Copy the cell. Select the required cells from A13 to An. Right clickPaste SpecialFormulas..OK If this post helps click Yes --------------- Jacob Skaria "Jean" wrote: I am trying to autofill a formula. I am in cell A12. Assuming that I want to multiply A10*J1. When I autofill it across, I would like the A10 to change to A11, A12, etc. However, I want the J1 to change to J2, J3, etc. Absolutes will not work. I'm sure that this isn't simple multiplication. Does anyone have a function that will do this? Thanks. |
Autofill issue
It's close...however, the J is changing to a K...it needs to copy down to J2,
J3, etc... "Mike H" wrote: hi, Try this in a12 and drag right =INDIRECT("A"&COLUMN(J10))*INDIRECT("J"&COLUMN(A1) ) Mike "Jean" wrote: I am trying to autofill a formula. I am in cell A12. Assuming that I want to multiply A10*J1. When I autofill it across, I would like the A10 to change to A11, A12, etc. However, I want the J1 to change to J2, J3, etc. Absolutes will not work. I'm sure that this isn't simple multiplication. Does anyone have a function that will do this? Thanks. |
Autofill issue
Oops, Jean please ignore the below post. I misread..
-- If this post helps click Yes --------------- Jacob Skaria "Jacob Skaria" wrote: In A12 =A10*J1 Copy the cell. Select the required cells from A13 to An. Right clickPaste SpecialFormulas..OK If this post helps click Yes --------------- Jacob Skaria "Jean" wrote: I am trying to autofill a formula. I am in cell A12. Assuming that I want to multiply A10*J1. When I autofill it across, I would like the A10 to change to A11, A12, etc. However, I want the J1 to change to J2, J3, etc. Absolutes will not work. I'm sure that this isn't simple multiplication. Does anyone have a function that will do this? Thanks. |
Autofill issue
I think I'm all set, Mike...I ust needed to make the J and absolute. Thanks
so much!!!! "Mike H" wrote: hi, Try this in a12 and drag right =INDIRECT("A"&COLUMN(J10))*INDIRECT("J"&COLUMN(A1) ) Mike "Jean" wrote: I am trying to autofill a formula. I am in cell A12. Assuming that I want to multiply A10*J1. When I autofill it across, I would like the A10 to change to A11, A12, etc. However, I want the J1 to change to J2, J3, etc. Absolutes will not work. I'm sure that this isn't simple multiplication. Does anyone have a function that will do this? Thanks. |
Autofill issue
So sorry...it's still not working. If I Absolute the J, it does remain in
column J. However, the formula is not dropping down to the next row in column J. "Mike H" wrote: hi, Try this in a12 and drag right =INDIRECT("A"&COLUMN(J10))*INDIRECT("J"&COLUMN(A1) ) Mike "Jean" wrote: I am trying to autofill a formula. I am in cell A12. Assuming that I want to multiply A10*J1. When I autofill it across, I would like the A10 to change to A11, A12, etc. However, I want the J1 to change to J2, J3, etc. Absolutes will not work. I'm sure that this isn't simple multiplication. Does anyone have a function that will do this? Thanks. |
Autofill issue
The highlighted references does not matter. If you are looking at
A10*J1 A11*J2 A12*J3 the formula should work =INDIRECT("A"&COLUMN(J1))*INDIRECT("J"&COLUMN(A1)) If this post helps click Yes --------------- Jacob Skaria "Jean" wrote: So sorry...it's still not working. If I Absolute the J, it does remain in column J. However, the formula is not dropping down to the next row in column J. "Mike H" wrote: hi, Try this in a12 and drag right =INDIRECT("A"&COLUMN(J10))*INDIRECT("J"&COLUMN(A1) ) Mike "Jean" wrote: I am trying to autofill a formula. I am in cell A12. Assuming that I want to multiply A10*J1. When I autofill it across, I would like the A10 to change to A11, A12, etc. However, I want the J1 to change to J2, J3, etc. Absolutes will not work. I'm sure that this isn't simple multiplication. Does anyone have a function that will do this? Thanks. |
Autofill issue
What I would like the formula to do is:
A10*J1 B10*J2 C10*J3 "Jacob Skaria" wrote: The highlighted references does not matter. If you are looking at A10*J1 A11*J2 A12*J3 the formula should work =INDIRECT("A"&COLUMN(J1))*INDIRECT("J"&COLUMN(A1)) If this post helps click Yes --------------- Jacob Skaria "Jean" wrote: So sorry...it's still not working. If I Absolute the J, it does remain in column J. However, the formula is not dropping down to the next row in column J. "Mike H" wrote: hi, Try this in a12 and drag right =INDIRECT("A"&COLUMN(J10))*INDIRECT("J"&COLUMN(A1) ) Mike "Jean" wrote: I am trying to autofill a formula. I am in cell A12. Assuming that I want to multiply A10*J1. When I autofill it across, I would like the A10 to change to A11, A12, etc. However, I want the J1 to change to J2, J3, etc. Absolutes will not work. I'm sure that this isn't simple multiplication. Does anyone have a function that will do this? Thanks. |
Autofill issue
Try
=INDEX(10:10,1,COLUMN(A1))*INDIRECT("J"&COLUMN(A1) ) If this post helps click Yes --------------- Jacob Skaria "Jean" wrote: What I would like the formula to do is: A10*J1 B10*J2 C10*J3 "Jacob Skaria" wrote: The highlighted references does not matter. If you are looking at A10*J1 A11*J2 A12*J3 the formula should work =INDIRECT("A"&COLUMN(J1))*INDIRECT("J"&COLUMN(A1)) If this post helps click Yes --------------- Jacob Skaria "Jean" wrote: So sorry...it's still not working. If I Absolute the J, it does remain in column J. However, the formula is not dropping down to the next row in column J. "Mike H" wrote: hi, Try this in a12 and drag right =INDIRECT("A"&COLUMN(J10))*INDIRECT("J"&COLUMN(A1) ) Mike "Jean" wrote: I am trying to autofill a formula. I am in cell A12. Assuming that I want to multiply A10*J1. When I autofill it across, I would like the A10 to change to A11, A12, etc. However, I want the J1 to change to J2, J3, etc. Absolutes will not work. I'm sure that this isn't simple multiplication. Does anyone have a function that will do this? Thanks. |
Autofill issue
YES!!!!!! Thanks so much!
"Jacob Skaria" wrote: Try =INDEX(10:10,1,COLUMN(A1))*INDIRECT("J"&COLUMN(A1) ) If this post helps click Yes --------------- Jacob Skaria "Jean" wrote: What I would like the formula to do is: A10*J1 B10*J2 C10*J3 "Jacob Skaria" wrote: The highlighted references does not matter. If you are looking at A10*J1 A11*J2 A12*J3 the formula should work =INDIRECT("A"&COLUMN(J1))*INDIRECT("J"&COLUMN(A1)) If this post helps click Yes --------------- Jacob Skaria "Jean" wrote: So sorry...it's still not working. If I Absolute the J, it does remain in column J. However, the formula is not dropping down to the next row in column J. "Mike H" wrote: hi, Try this in a12 and drag right =INDIRECT("A"&COLUMN(J10))*INDIRECT("J"&COLUMN(A1) ) Mike "Jean" wrote: I am trying to autofill a formula. I am in cell A12. Assuming that I want to multiply A10*J1. When I autofill it across, I would like the A10 to change to A11, A12, etc. However, I want the J1 to change to J2, J3, etc. Absolutes will not work. I'm sure that this isn't simple multiplication. Does anyone have a function that will do this? Thanks. |
All times are GMT +1. The time now is 01:44 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com