How to remove rows in Excel based on conditions: Example every 5th row or First row in every 5 rows

This video teaches how to remove rows in excel based on criteria: like you want to remove every 5th row, or you want to delete the first row of each consecutive five rows. You can use this method even when the position of the row you want to remove is not the fifth row. Example, you want to delete alternate rows or the every third row.