I have an Excel spreadsheet with over 10,000 entries. This spreadsheet contains two columns of dates, and I need to select only those entries where the dates do NOT match in the two columns.
The problem is, the dates have been differently formatted and are embedded within other information, like this:
Sometimes the two columns have used exactly the same formatting and I can exclude these using the IF function. However in many cases the date may have been entered differently in the second column, like
$obj->parsedDate(">=",1997,3,1), so the numbers will be the same but some of the other characters will not not.
Can Excel look for just the numbers and identify matches in this way?