How to Copy Every Nth Row in Excel

[@yerikyerik]

it is interesting that you propose different solutions, this gives good ideas

[@xlpedia]

Thank you 😊

[@BeatsbyTheHuman]

I keep getting the spill error. I am looking for it to return every 3rd result from a row, not a column, starting at a specified point as "1" for counting cells to return the 3rd.

[@xlpedia]

#SPILL error occurs when there is not enough space for the output array. Try clearing everything after the formula cell. You can also let me know the formula you're using.

[@yashvardhanpandey4523]

if formula is showing #### instead of data

[@yashvardhanpandey4523]

same ### in offset formula

[@yashvardhanpandey4523]

FILTER is not valid

[@xlpedia]

Please check the formulas carefully, check if the formula cell has proper formatting, check the system date settings if the output is a date, extend the formula cell so that it can occupy the output contents. And for the FILTER function, it is only available on newer excel versions.

[@anoopt8858]

This formula is not working in Excel2010

[@xlpedia]

Sorry😥 The FILTER Function is not available on older versions.

[@aubreeeverett3625]

*Promo SM*

[@xlpedia]

Ok.