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 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 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.


Related:

1 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 555
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

Similar discussions

encryption message several time in chat
measking -
HelpiOS -

1 response
Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response