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!!