Selecting every other row with formula and filter

When working with larger worksheets, the task of selecting alternate rows becomes much simpler by utilizing a helper column and the Filter functionality. Follow the steps below to achieve this:

In an empty column next to your dataset, enter one of these formulas:

=ISODD(ROW())
=ISEVEN(ROW())

Select every third row. Change the 3 to whatever number row to select

=OFFSET($A$1,(ROW()-1)*3,0)