Compare dates in excel

[Closed]
Report
Posts
2
Registration date
Thursday November 8, 2012
Status
Member
Last seen
November 8, 2012
-
Posts
2818
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 18, 2021
-
Hello,


Hello,

I have two excel sheets.

In sheet one i have certain dates associated with certain IDs.

In sheet two i have certain dates associated with certain IDs.

I want to compare the IDs from both sheet and pick the data from sheet two for only dates which are before the date for sheet 1 for each ID.


1 reply

Posts
2818
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 18, 2021
486
Hi Priyanka,

Could you upload a sample file (with .xls extention) to a file sharing site like www.speedyshare.com to write a more specific code for you.

Best regards,
Trowa