If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
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. |
|
Thread Tools | |
Display Modes | |
|
|