Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Autofill cell reference forumula not working
Hi.
I have a row in which each cell references another cell. Format looks like this: U7 =D46 U8 =D115 U9 =D184 Notice that each cell is still referencing column D, but moves up in sequence by 69 When I highlight and drag (I need to continue this series all the way to U66), Excel is returning =D49 in cell U10, and =D118 in cel U11...it does not maintain the series. Driving me bonkers, what do I need to do to continue the series without manually entering the formula? Done right, U10 should be =D253, U11 shoudl be =D322, etc. -- Thank you all for your help! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Autofill cell reference forumula not working
=INDIRECT("D"&(ROW()-7)*69+46)
-- Kind regards, Niek Otten Microsoft MVP - Excel "James D" wrote in message ... Hi. I have a row in which each cell references another cell. Format looks like this: U7 =D46 U8 =D115 U9 =D184 Notice that each cell is still referencing column D, but moves up in sequence by 69 When I highlight and drag (I need to continue this series all the way to U66), Excel is returning =D49 in cell U10, and =D118 in cel U11...it does not maintain the series. Driving me bonkers, what do I need to do to continue the series without manually entering the formula? Done right, U10 should be =D253, U11 shoudl be =D322, etc. -- Thank you all for your help! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Autofill cell reference forumula not working
Hi,
Put this in U7 and drag down =INDEX(D46:D1000,(ROW(A1)-1)*69+1) Mike "James D" wrote: Hi. I have a row in which each cell references another cell. Format looks like this: U7 =D46 U8 =D115 U9 =D184 Notice that each cell is still referencing column D, but moves up in sequence by 69 When I highlight and drag (I need to continue this series all the way to U66), Excel is returning =D49 in cell U10, and =D118 in cel U11...it does not maintain the series. Driving me bonkers, what do I need to do to continue the series without manually entering the formula? Done right, U10 should be =D253, U11 shoudl be =D322, etc. -- Thank you all for your help! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Autofill cell reference forumula not working
Try this:
=INDEX(D$46:D$4200,ROWS(U$7:U7)*69-69+1) -- Biff Microsoft Excel MVP "James D" wrote in message ... Hi. I have a row in which each cell references another cell. Format looks like this: U7 =D46 U8 =D115 U9 =D184 Notice that each cell is still referencing column D, but moves up in sequence by 69 When I highlight and drag (I need to continue this series all the way to U66), Excel is returning =D49 in cell U10, and =D118 in cel U11...it does not maintain the series. Driving me bonkers, what do I need to do to continue the series without manually entering the formula? Done right, U10 should be =D253, U11 shoudl be =D322, etc. -- Thank you all for your help! |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Autofill cell reference forumula not working
THAT GOT IT!!
Thanks! I've got a total of 30 columns that have similar references...can you imagine how long it would take to manually do this! You've saved me. -- Thank you all, very much, for your help! "T. Valko" wrote: Try this: =INDEX(D$46:D$4200,ROWS(U$7:U7)*69-69+1) -- Biff Microsoft Excel MVP "James D" wrote in message ... Hi. I have a row in which each cell references another cell. Format looks like this: U7 =D46 U8 =D115 U9 =D184 Notice that each cell is still referencing column D, but moves up in sequence by 69 When I highlight and drag (I need to continue this series all the way to U66), Excel is returning =D49 in cell U10, and =D118 in cel U11...it does not maintain the series. Driving me bonkers, what do I need to do to continue the series without manually entering the formula? Done right, U10 should be =D253, U11 shoudl be =D322, etc. -- Thank you all for your help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help me Please! Reference cell working w subtotals | Excel Discussion (Misc queries) | |||
How to autofill the same cell reference across multiple worksheet. | Excel Worksheet Functions | |||
Using IF function then Autofill-increments down a reference cell | Excel Worksheet Functions | |||
Cell reference in vlookup not working | Excel Worksheet Functions | |||
Autofill based on a cell reference | Excel Worksheet Functions |