Hey I've been trying to find a way to delete the rows I need via formula without having to do change to much before it works.
When I download CSV, it stores time/date like this:
08:56 29-Sep
07:56 29-Sep
07:15 29-Sep
03:29 29-Sep
09:15 29-Sep
05:15 29-Sep
09:30 29-Sep
06:15 29-Sep
Each one being on a different row.
What I'm trying to do is delete certain rows based on a set criteria.
The criteria being Before 09:00 on today's date, and after 05:00 on tomorrow's date.
Is this possible without splitting the data up?
I've been trying to do it via IF statement, but don't use excel for much more than the basics to be honest.
There are several ways to achieve this.
Formulas cannot delete data. Formulas can help you identify data, and then you can use that for sorting or filtering data.