Compare dates and unique identifier

V

vg09

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

Stefi

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:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to find earliest record based on unique identifier from a list ofdata 4
excel spreadsheet compare 3
Compare current month totals with last months totals 1
Compare two dates 3
Selecting only rows of data with unique identifier 1
Compare Data in two Separate Worksheets 3
matching 2
Update Query - Want to Update Only the First Match 4

Top