Compare 2 Spreadsheets

[jhmhothers]

Hi,
I am trying to compare 2 spreadsheets ( CURR and PREV ) of employees' absences. The columns are the same in both. There may be multiple rows per employee. What I would like to do is :
1) Use CURR as the base to compare
2) If the Employee is found in CURR but not in PREV, return FALSE
4) If the Employee is found in both, check all the rows for the employee in CURR against all the rows in PREV
a) return TRUE if corresponding rows are found
i) col 53 (Start), col 54 (End), col 55(Duration) and col 57(Type) are the same
b) return FALSE if no corresponding row is found
Could you please advise how I should go about doing it?
Thanks for your help.

 

[texasalynn]

Welcome to MrExcel board...

where do you want to display the answers? ie 2) False

post a small sample of your data layout

 

[jhmhothers]

Hi Texasalynn,
My apology for the late reply.
I would like to store the "true" / "false" result in the last column of the CURR worksheet.
Below is a sample set of the CURR and PREV worksheets.
Thanks very much for your help

CURR
Emp No Start End Dur Type True/False
1111 2011-04-08 2011-04-08 0.5 012 TRUE
1111 2011-04-18 2011-04-18 1 021 TRUE
1111 2011-04-19 2011-04-19 1 021 TRUE
1111 2011-05-06 2011-05-06 1 010 TRUE
1111 2011-05-24 2011-05-24 1 010 TRUE
1111 2011-05-25 2011-05-25 1 010 TRUE
1111 2011-05-26 2011-05-26 1 010 TRUE
1111 2011-05-27 2011-05-27 1 010 TRUE
1111 2011-05-30 2011-05-30 1 010 TRUE
1111 2011-05-31 2011-05-31 1 010 TRUE
1111 2011-06-01 2011-06-01 1 010 FALSE
1111 2011-06-02 2011-06-02 1 010 FALSE
1111 2011-06-03 2011-06-03 1 010 FALSE
2222 2011-01-21 2011-01-21 1 010 TRUE
2222 2011-01-28 2011-01-28 1 010 TRUE
2222 2011-02-15 2011-02-15 1 010 TRUE
2222 2011-03-24 2011-03-24 0.5 012 TRUE
2222 2011-05-09 2011-05-09 1 010 TRUE
2222 2011-05-10 2011-05-10 0.5 011 FALSE
2222 2011-05-11 2011-05-11 1 010 TRUE
2222 2011-05-12 2011-05-12 1 010 FALSE
2222 2011-05-13 2011-05-13 1 010 FALSE
2222 2011-05-16 2011-05-16 1 010 FALSE
2222 2011-05-18 2011-05-18 1 010 TRUE
2222 2011-05-19 2011-05-19 1 010 TRUE
2222 2011-06-07 2011-06-07 1 010 FALSE
2222 2011-08-05 2011-08-05 1 010 TRUE
2222 2011-08-08 2011-08-08 1 010 TRUE
3333 2011-01-13 2011-01-13 0.5 012 FALSE
3333 2011-01-26 2011-01-26 0.5 012 FALSE

PREV
Emp No Start End Dur Type
1111 2011-04-08 2011-04-08 0.5 012
1111 2011-04-18 2011-04-18 1 021
1111 2011-04-19 2011-04-19 1 021
1111 2011-05-06 2011-05-06 1 010
1111 2011-05-24 2011-05-24 1 010
1111 2011-05-25 2011-05-25 1 010
1111 2011-05-26 2011-05-26 1 010
1111 2011-05-27 2011-05-27 1 010
1111 2011-05-30 2011-05-30 1 010
1111 2011-05-31 2011-05-31 1 010
2222 2011-01-21 2011-01-21 1 010
2222 2011-01-28 2011-01-28 1 010
2222 2011-02-15 2011-02-15 1 010
2222 2011-03-24 2011-03-24 0.5 012
2222 2011-05-09 2011-05-09 1 010
2222 2011-05-10 2011-05-10 1 010
2222 2011-05-11 2011-05-11 1 010
2222 2011-05-18 2011-05-18 1 010
2222 2011-05-19 2011-05-19 1 010