Lewisjsimpson
New Member
- Joined
- Aug 29, 2022
- Messages
- 2
- Platform
- Windows
Hello,
Was hoping someone might be able to assist. I've got a mass amount of data, over 220000 lines that I'd like to reduce. Data was taken off a flow meter I had installed that took readings every 5 seconds over the course of a month. I want to delete alot of the data so that there is only one reading every minute.
Is there a macro or code I can use that can delete rows from the spreadsheet while keeping one row for each minute? Otherwise I'm going to have to go through each line individually and delete them?
Thanks,
Lewis
Was hoping someone might be able to assist. I've got a mass amount of data, over 220000 lines that I'd like to reduce. Data was taken off a flow meter I had installed that took readings every 5 seconds over the course of a month. I want to delete alot of the data so that there is only one reading every minute.
Is there a macro or code I can use that can delete rows from the spreadsheet while keeping one row for each minute? Otherwise I'm going to have to go through each line individually and delete them?
Thanks,
Lewis