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.
Next Steps in your Excel journey
Now that you have learnt this, compare your Excel skills to the rest of the world. Below the average Excel Skill Assessment scores from our worldwide audience.
How do your Excel skills compare to your colleagues and work mates? This is a free skills assessment which will help you identify your Excel strengths and weaknesses.
