Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Offset function
Hi
How can I use Offset function to copy formulae, in one column and 4 rows, or every 4 rowas Thnaks in Advance Jam |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Offset function
Can we see an example of what you expect to see when the formula is copied
down? " wrote: Hi How can I use Offset function to copy formulae, in one column and 4 rows, or every 4 rowas Thnaks in Advance Jam |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Offset function
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Offset function
I am not certain that I understand your request any better than the others,
but perhaps these formulas will assist you. Condition: You have formulas showing value in column A beginning at row 1. You wish to obtain a list of the values from column A at row 1, row 1+4 [row 5], row 1+(2*4) [row 9], et cetera. This formula in another cell on row 1 and filled down would do that: =OFFSET($A$1,(ROW()-ROW($A$1))*4,0) If your information was in column G and began at row 2, then this formula in another column on row 2 and filled down would achieve similar results: =OFFSET($G$2,(ROW()-ROW($G$2))*4,0) " wrote: Hi How can I use Offset function to copy formulae, in one column and 4 rows, or every 4 rowas Thnaks in Advance Jam |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Offset function
Hi,
If you are trying to sum every 4th row then here is one approach: =SUM(SUM(INDIRECT("F"&ROW(A1:A20)*4))) This is array entered: This means press Shift+Ctrl+Enter instead of Enter. This formula adds the items in F4, F8, F12... Or you can use the non array version: =SUMPRODUCT(SUM(INDIRECT("F"&ROW(A1:A20)*4))) If this helps, please click the Yes button. -- Thanks, Shane Devenshire " wrote: Hi How can I use Offset function to copy formulae, in one column and 4 rows, or every 4 rowas Thnaks in Advance Jam |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Offset function
Hi Mike
I want to copy formulae in one sheet, this formulae is referring to other sheet, in sheet1 the formulae repeat every 4 rows, ex. A11, A15, etc.. In the sheet2 this formulae refering to sheet1 is repeating every 3 rows, ex. A10, A13, etc.., so the increament is minus 1, when I drag or copy and paste, it gives the result of one row higher, and I have to adjust the cell number every time. Sheet1 A11 formulae A15 formulae in sheet2 A10 should be as A11 in sheet1 A13 shoulkd be as A15 in sheet1 Hope I am clear Thanks in advance Jam Mike H wrote: Can we see an example of what you expect to see when the formula is copied down? " wrote: Hi How can I use Offset function to copy formulae, in one column and 4 rows, or every 4 rowas Thnaks in Advance Jam |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
XL2002 - OFFSET function and LARGE function | Excel Worksheet Functions | |||
offset and Sum function | Excel Worksheet Functions | |||
Offset Function | Excel Worksheet Functions | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
help with offset function | Excel Worksheet Functions |