LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 46
Default Delete rows depending on time value

I have around 30 spreadsheets with a series of values including those
shown below. I need to remove all rows with the 5 minute entries and
keep those with the 10 minute entries.

From this:
30/09/2018 07:15 23959.093 0
30/09/2018 07:20 23959.093 0
30/09/2018 07:25 23959.093 0
30/09/2018 07:30 23959.093 0
30/09/2018 07:35 23959.094 0.012
30/09/2018 07:40 23959.099 0.06
30/09/2018 07:45 23959.108 0.108
30/09/2018 07:50 23959.118 0.12
30/09/2018 07:55 23959.123 0.06
30/09/2018 08:00 23959.127 0.048
30/09/2018 08:05 23959.132 0.06
30/09/2018 08:10 23959.138 0.072
30/09/2018 08:15 23959.145 0.084
30/09/2018 08:20 23959.153 0.096
30/09/2018 08:25 23959.162 0.108
30/09/2018 08:30 23959.173 0.132
30/09/2018 08:35 23959.185 0.144
30/09/2018 08:40 23959.199 0.168
30/09/2018 08:45 23959.215 0.192
30/09/2018 08:50 23959.234 0.228
30/09/2018 08:55 23959.256 0.264
30/09/2018 09:00 23959.28 0.288
30/09/2018 09:05 23959.306 0.312
30/09/2018 09:10 23959.336 0.36
30/09/2018 09:15 23959.366 0.36
30/09/2018 09:20 23959.4 0.408
30/09/2018 09:25 23959.434 0.408

To this:
30/09/2018 07:20 23959.093 0
30/09/2018 07:30 23959.093 0
30/09/2018 07:40 23959.099 0.06
30/09/2018 07:50 23959.118 0.12
30/09/2018 08:00 23959.127 0.048
30/09/2018 08:10 23959.138 0.072
30/09/2018 08:20 23959.153 0.096
30/09/2018 08:30 23959.173 0.132
30/09/2018 08:40 23959.199 0.168
30/09/2018 08:50 23959.234 0.228
30/09/2018 09:00 23959.28 0.288
30/09/2018 09:10 23959.336 0.36
30/09/2018 09:20 23959.4 0.408



Any help would be appreciated!


--
F


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Delete rows if time is greater than present time Sabosis Excel Programming 2 January 14th 13 02:12 PM
delete the non blank rows depending on Column Harn88 Excel Programming 1 November 18th 08 08:37 AM
Delete variable # of rows depending on conditions Pman Excel Programming 5 September 27th 07 03:27 PM
Delete rows depending on cell Value Tomas Stroem Excel Programming 3 June 8th 07 10:36 AM
How to delete a set of rows depending on Value msbutton27 Excel Discussion (Misc queries) 1 January 15th 06 04:57 PM


All times are GMT +1. The time now is 06:31 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"