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.
Black Friday- Free MS Excel Course
We are offering a very special SPECIAL on Black Friday.
For the one day only another course will appear on the Free courses list. Visit the Free Online MS Excel Courses on Friday to see which course it is!