| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy paste formula to skip rows
Ok, so i have a basic return formula =(E31-E18-E28-E27)/E18 in cell E1208 and
it returns the value I'm looking for. Now what I'm trying to do is copy this formula and paste it the cell below, E1209, however I need it to return the formula of =(E44-E31-E41-E40). I can't seem to offset it every 13 rows and need to formula that I can copy down quite a few times. Can nayone help?? Please advise... Thank!!! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
copy paste formula to skip rows
try this for your first formula, then copy it down
=(OFFSET(E$31,13*(ROW(A1)-1),0)-OFFSET(E$18,13*(ROW(A1)-1),0)- SUM(OFFSET(E$27,13*(ROW(A1)-1),0,2,1)))/OFFSET(E$31,13*(ROW(A1)-1),0) "Greg" wrote: Ok, so i have a basic return formula =(E31-E18-E28-E27)/E18 in cell E1208 and it returns the value I'm looking for. Now what I'm trying to do is copy this formula and paste it the cell below, E1209, however I need it to return the formula of =(E44-E31-E41-E40). I can't seem to offset it every 13 rows and need to formula that I can copy down quite a few times. Can nayone help?? Please advise... Thank!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert rows based on specific value | Excel Worksheet Functions | |||
| formula for copy and paste | New Users to Excel | |||
| I want to copy a formula n Excel but skip any blank cells | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Copy and Paste Formula Without the linked file path | Excel Worksheet Functions | |||
Linear Mode
