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:
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.
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:
Subscribe to:
Post Comments (Atom)
Very cool and very useful!
ReplyDeleteThanks GG!
P