Changes abound

Time to change up this blog.  It has been many years since we posted here.  And, while gaming in the classroom is still important, my role has changed over the years.  Here I will try to post things that I find that are helpful to complete some of my tasks in the classroom as a technology coordinator.  As such, here is the first new thing (which is really an old thing since it is an Excel formula that has been around for a long time!).

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.