Forum Discussion
Delete Multiple Rows in repeating sequences throughout sheet
I have mass data in the form of 5 minutes readings over the course of a month but I only need the hourly reading. I want to be able to delete the other 11 rows of data throughout. Meaning I want to ke...
The column containing the minute is all of the date/time info. It is given in the form year-month-day-hour-min so some thing like 201004010100 is given. Thus they aren't exactly repeating unless I can filter by the final number of it somehow?
Was able to use the right function to extract the minutes from the number and then filter that way