| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula increment
How do you increment a formula by 12? I have some data that I can copy and
paste in excel, and the info I want appears on every 12th row. So, I want to be able to paste it, and create a formula that will automatically pull whatever values are in G1, G13, G25, and so on. Thanks! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula increment
=OFFSET($G$1,(ROWS($1:1)-1)*12,0)
"in2ition" wrote: How do you increment a formula by 12? I have some data that I can copy and paste in excel, and the info I want appears on every 12th row. So, I want to be able to paste it, and create a formula that will automatically pull whatever values are in G1, G13, G25, and so on. Thanks! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula increment
On Jun 24, 9:26 am, in2ition
wrote: How do you increment a formula by 12? I have some data that I can copy and paste in excel, and the info I want appears on every 12th row. So, I want to be able to paste it, and create a formula that will automatically pull whatever values are in G1, G13, G25, and so on. Thanks! Maybe =INDIRECT("G" & ROWS(A$1:A1)*12-11) Ken Johnson |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula increment
That works. Thanks, so much!
"Teethless mama" wrote: =OFFSET($G$1,(ROWS($1:1)-1)*12,0) "in2ition" wrote: How do you increment a formula by 12? I have some data that I can copy and paste in excel, and the info I want appears on every 12th row. So, I want to be able to paste it, and create a formula that will automatically pull whatever values are in G1, G13, G25, and so on. Thanks! |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula increment
Here is a non-volatile offering...
=INDEX(G$1:G$1001,12*ROWS($1:1)-11) Set the top end on the G$1:G$1001 range to suit your needs. Rick "in2ition" wrote in message ... How do you increment a formula by 12? I have some data that I can copy and paste in excel, and the info I want appears on every 12th row. So, I want to be able to paste it, and create a formula that will automatically pull whatever values are in G1, G13, G25, and so on. Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| increment Address formula | Excel Discussion (Misc queries) | |||
| increment an index in a formula | Excel Discussion (Misc queries) | |||
| MONTH INCREMENT FORMULA | Excel Discussion (Misc queries) | |||
| Increment formula for time | Excel Discussion (Misc queries) | |||
| How do I increment a formula? | Excel Worksheet Functions | |||
Linear Mode
