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 Moderator 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 Moderator Last seen December 27, 2022 552
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

Similar discussions

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
Comparing Two Excel Sheets and copying like data to third sheet
coz2992 -
TrowaD -

11 responses