LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
SU SU is offline
external usenet poster
 
Posts: 25
Default Deleting Rows of Data

I have a spreadsheet with 38000 rows of data. The data comes in with date
(01/01/01) in column A and time (12:00:00) in Column B. The data is recorded
every 5 secs.

I would only want to keep data every 5 mins and delete the rest. I gather
this can be done in two ways:

1) by deleting 'x' number of rows below the first data and repeat the process.

2) by matching values **:00:00, **:05:00, **:10:00 and such in Column B and
deleting the rest of the columns.

Can anyone help me with a macro to do this?

Many thanks.
 
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
Deleting Rows with data duplicated in 2 columns [email protected] Excel Worksheet Functions 7 April 10th 07 07:18 PM
deleting various rows of cell data throughout the master list tha. Flip Excel Discussion (Misc queries) 1 August 8th 06 03:14 PM
Pivot Table - Deleting data rows while maintaining them in the tot Robert Hamilton Excel Worksheet Functions 0 June 7th 06 07:39 PM
deleting hidden rows so i can print only the rows showing?????? jenn Excel Worksheet Functions 0 October 6th 05 04:05 PM
Deleting rows containing common data gcotterl Excel Discussion (Misc queries) 1 January 4th 05 12:58 AM


All times are GMT +1. The time now is 11:42 PM.

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"