Link to home
Create AccountLog in
Avatar of -Dman100-
-Dman100-Flag for United States of America

asked on

find non matching columns

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.
extract.csv
ASKER CERTIFIED SOLUTION
Avatar of Tracy
Tracy
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of -Dman100-

ASKER

Thank you!