Dazzawm
Well-known Member
- Joined
- Jan 24, 2011
- Messages
- 3,748
- Office Version
- 365
- Platform
- Windows
I have a large data file like below. I have a data column where there are errors where the end date is before the start date! I need a code please to highlight these.
I have highlighted above what sort of format and errors occur. There are various columns of data either side but I can adapt the code to the column it needs to look at in each different file I use it on.
Thanks
StartEndDate |
11/2013->12/2014 |
11/2013->02/2018 |
03/2013->11/2013 |
01/2017->12/2014 |
11/2013->02/2018 |
05/2013->11/2013 |
01/2017->12/2014 |
I have highlighted above what sort of format and errors occur. There are various columns of data either side but I can adapt the code to the column it needs to look at in each different file I use it on.
Thanks