Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello All,
I have a group of data that was recorded 6 times every minute for a year. I need to only keep one row at the top of each hour. I wrote a script and have it running now. It checks each row and if the minute in that row is not 0 then it deletes it, if it is zero it deletes the next 5 rows then skips one row. I've had it running for about 10 minutes now and I'm through with about a day of data. Is there a faster way of doing it? Thanks -- Brian |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macros or the Fastest way to Autofill Rows | Excel Discussion (Misc queries) | |||
Repeating a Cell Format For Many Rows: What's Fastest Way? | Excel Discussion (Misc queries) | |||
How to delete rows when List toolbar's "delete" isnt highlighted? | Excel Worksheet Functions | |||
Fastest Way to Filter/Delete | Excel Worksheet Functions | |||
Delete every 3rd row, then delete rows 2-7, move info f/every 2nd row up one to the end and delete the row below | Excel Programming |