I was presented with a list of rows in Excel and I wanted to delete the columns that I don't want. Using the mod formula, it was easy to delete the rows that I didn't want. I got the info from here: https://www.techrepublic.com/blog/microsoft-office/quickly-delete-every-nth-row-in-an-excel-worksheet/
What you do first is do a sequence number list (1, 2, 3, etc) in a column of your choosing (an empty one). Then, in the next column, use the formula =mod(firstcellinsequence,n) where firstcellinsequence is the first cell in the column of numbers (so the one that has the number 1 in it). The n is the row that you want to delete. So, if you want to delete every other row, with a list that started at row 1 column C, your formula would be =mod(C1,2). Then drag this formula down to all the cells with data in it. You should get a answer of 0 in first column and 1 in the second column. Then it will repeat itself (0, 1, 0, 1, etc...).
Then use the filter feature to just show the rows with a 1 in it. Highlight those rows and delete them all. Then remove the filter. You will be left with just the rows you need. Pretty cool formula.