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.
Subscribe to our YouTube Channel
We release a new video every weekday. Look out for our ‘Excel Hacks in 2 minutes or less’ playlist.
Below a popular video.
Finding errors in your Excel spreadsheets with ExcelAnalyzer
Watch, like, subscribe, click the bell!