How do I select every third row in an Excel spreadsheet?

Question

I'm trying to select every third row in an Excel spreadsheet and delete the others.

Answer 1

Hello, Peter! Are you okay using a helper column?

Here’s a simple way:

• Add a new column next to your data.
• In the first row, enter =MOD(ROW(),3)=0.
• Drag the formula down the column.
• Filter the column for TRUE. This selects every third row.
• Copy those rows to a new sheet or delete the others.

This uses standard Excel tools and works without macros. Hope it helps!

Warm regards,

Arlene D.

Answer 2

Hi,

Assuming the entries in column are unique, in cell C2, enter this formula

=LET(r,A2:A19,FILTER(r,MOD(XMATCH(r,r),3)=1))

Hope this helps.

Answer 3

"Assuming" you want to return every third item starting at position 1. Nice to see the use of 365.

However, just be aware of the logic error using that method.

Here, the seperate word "CAT" is not a word that should be returned. Another way would return the results as shown in G2.