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
|