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 keep a row out of every 12 rows for 8000 and I have been unable to find an efficient way to do so.
3 Replies
Do you have a column contains the information of "Minute of the time"? If yes, I think you can use filter to perform (although it does not delete the redundant row) your task. You may consider the function Minute to get the information of "Minute of the time".
- 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
