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.
Who wants to be a ... Advanced Excel user?
3 random questions based on our popular YouTube playlist of Excel hacks in 2 minutes or less. Guess the answer, view the result and watch the video clip for more details.
Subscribe to our YouTube channel- Today’s Excel Tip for the day