Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Thanks to all who reply to our sometimes obvious questions. This one has me
stumped. I import a converted file from a data recorder that records date, time, flow rate, pressure, and water level. The format goes like this A1 - Date B1 - Time D1/E1 - Flow F1/G1 - Pressure H1/I1 - Water Level The columns do not have headers. The data is recorded every minute. Now for the problem: what I would like to do is delete the rows so that the data is now in five minute intervals. Currently I highlite the rows that I dont need and then delete them however there are generaly 5k to 100k rows. Lots of time! Looking for some ideas or help Thanks Cliff |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
deleting hidden rows so i can print only the rows showing?????? | Excel Worksheet Functions | |||
auto deleting defined rows | Excel Discussion (Misc queries) | |||
Deleting unwanted and empty rows.... | New Users to Excel | |||
Deleting unwanted and empty rows... | Excel Discussion (Misc queries) | |||
Deleting rows containing common data | Excel Discussion (Misc queries) |