Note that you should tack on a +A1 to the end if you want to include cell A1 (since you want A128, A64, and A1, the A1 doesn't follow the 64th row pattern...)
Thanks, no error now, but I'm not getting the values from the referenced cells in the formula cell.
Have I explained myself badly?
All I need is the actual value in the reference cells (so SUM is probably not necessary?)
So, I start with a column that's 65536 cells long, and end up with a column that's 1023 cells long with each cell having the value frome very 64th cell from the original column...
I think that explaines it better?
Thanks for the help; I really need to have this done in the next half hour!!!
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.