Hello,
I am currently working with a large excel file (currently about 54,000 rows). I am working with data points, and they are measured by the second, while I only need data points for once every minute. I have an elapsed time column that is measured in seconds.
Is there a way to quickly filter out or delete every row for which the elapsed time is not a multiple of 60? I am only seeing how to delete rows based on a single value in other forums. I'd think a macro might work for this, but I am not too familiar with writing those at the moment.
Any advice is appreciated!
Bookmarks