View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
in2ition in2ition is offline
external usenet poster
 
Posts: 2
Default 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!