Compare dates and unique identifier
 

I need to compare two sets of data having dates in coulum A and a numeric
unique identifier in colum B. I need to compare the date to the date and in
it dosent match then go to the next date, once the dates match i need to
compare the unique identifier of those two records and give an answer of true
or false. In short only when both the date and identifier matches the answer
should be true. Please help!!

Compare dates and unique identifier
 

If your two sets are in Sheet1 and Sheet2 then
=AND(A2=Sheet2!A2,B2=Sheet2!B2)
in Sheet1 C2 (dragged down as necessary) will return TRUE if both data
matches, FALSE if not.
Regards,
Stefi


€žvg09€� ezt Ã*rta:

I need to compare two sets of data having dates in coulum A and a numeric
unique identifier in colum B. I need to compare the date to the date and in
it dosent match then go to the next date, once the dates match i need to
compare the unique identifier of those two records and give an answer of true
or false. In short only when both the date and identifier matches the answer
should be true. Please help!!