We recently had a query of how to pull from a list, every 17th cell into a new column. The best bet would be the OFFSET function. For the reference cell you can refer to a the first cell and make it absolute. Then in the rows (or columns) use a multiple of the number you want e.g. in this case multiples of 17. The OFFSET will correctly pull through every 17th cell.
Images loading below. While you wait, can you answer this Excel related tip? Guess the answer then click SEE ANSWER to see how it can be done.
Extra MS Excel Tip
Did you know that you can copy/ paste a section of Excel into Word WITHOUT still seeing the gridlines, filter buttons and more!
Watch how to Remove gridlines from Excel paste as picture (opens in a new tab) on our YouTube channel (don’t forget to subscribe).