Hey Everyone!!
I have a bit of a conundrum. Once a week I have to do some data scrubbing on a file I get from my HR Team. The first step of this is to sort the list by the date column, W, so that the newest records are at the top. The problem is, there is zero consistency in this column. There are only dates in about half the rows, which is fine, but for the other half - there is zero consistency to how the date has been entered. Some of the cells are even text values. Which means, sorting the Column does not work...
Is there an easy(ish) way of converting all these values to a consistent date format that I could then sort as normal?
The attached document is a full example of what I am working with - about 81,000 rows.
Thanx a million for your help!!!
Bookmarks