Home |
Search |
Today's Posts |
#1
|
|||
|
|||
rows that need deleting
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 |
#2
|
|||
|
|||
rows that need deleting
Intervals from what? What will be the base time, 0 hours, or the first time?
And is it to delete any not exactly five minutes from, i.e. maybe delete everything? -- HTH RP (remove nothere from the email address if mailing direct) "LtFass" wrote in message ... 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 |
#3
|
|||
|
|||
rows that need deleting
Introduce a helper column J. In j1: =mod(minute(b1),5)). Autofill that
through column J. Then autofilter and in column J, select custom, does not equal 0. Delete the rows that remain visible, and you'll have your five-minute samples. "LtFass" wrote: 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 |
#4
|
|||
|
|||
rows that need deleting
The time base starts at say 09:00:00 and is recorded like this 09:01:00.
09:02:00 ect... what I need to do is remove 09:02:00 - 09:04:00 leaving only 09:01:00 then 09:05:00 and so on I hope this helps "Bob Phillips" wrote: Intervals from what? What will be the base time, 0 hours, or the first time? And is it to delete any not exactly five minutes from, i.e. maybe delete everything? -- HTH RP (remove nothere from the email address if mailing direct) "LtFass" wrote in message ... 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 |
#5
|
|||
|
|||
rows that need deleting
Thank you that worked very well all I needed to do was add one more ( between
the = and the Mod. Thanks again "bpeltzer" wrote: Introduce a helper column J. In j1: =mod(minute(b1),5)). Autofill that through column J. Then autofilter and in column J, select custom, does not equal 0. Delete the rows that remain visible, and you'll have your five-minute samples. "LtFass" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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) |