Taking every third value or the mean of three

1. How do I select every third row in Excel?

How do I select every third row in Excel?

Select Every nth Row

To get the every 3rd (nth) row, we change the number to divide by to 3 (n). We can switch the filter on to filter on the MOD result required to show specific rows.