| Home |
| Search |
| Today's Posts |
|
#3
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! |
| 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 | |||
Threaded Mode
