February 27, 2017

the wonder of offset in Google Sheets and Excel

Every once in awhile, you want to grab every 3rd row of a set of data. After a bit of searching online and trial and error, I got it to work!

The formula turns out to be =OFFSET('sheet name'!$A2, 0, (Column()-2*n) where n stands for whatever number of columns you want to offset.

Here's what the formula means:

Make sure you include that (Column()-2 part; notice that in my case, I wanted every 3rd column.

1 comment: