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
Watch the video below on YouTube and download the free SUMIFS COUNTIFS and AVERAGEIFS example file.
Full, free training on using SUMIFS, COUNTIFS and AVERAGEIFS.
We release at least one new video every week on a useful MS Excel Tip or Trick. Look out for our ‘Excel Hacks in 2 minutes or less’ playlist.
Watch, like and subscribe!