Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / General Excel Questions / May 2008

Tip: Looking for answers? Try searching our database.

Compare dates and unique identifier

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
vg09 - 22 May 2008 21:42 GMT
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!!
Stefi - 23 May 2008 09:34 GMT
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!!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.