Previous Topic Next Topic

Compare dates in excel

Closed
Priyanka1987
Posts
2
Registration date
Thursday November 8, 2012
Status
Member
Last seen
November 8, 2012
 - Nov 8, 2012 at 04:52 AM
TrowaD
Posts
2884
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 21, 2022
 - Nov 8, 2012 at 09:44 AM
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

Answer 1 / 1
TrowaD
Posts
2884
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 21, 2022
 512
Nov 8, 2012 at 09:44 AM
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
0