Can any Excel guru help me find where two columns "B" and "C" don't match? In column "B" I have a datetime value in the format: 2010-01-21T14:00:00.000Z
In column "C" I have a date value in the format: 1/21/2010
I want to find all records where the date value is different. I'm not concerned about the time.
See the attache .csv file.
Thanks for any help.