Spreadsheet: 196736d1354093061-eliminate-duplicates-based-on-different-variables-excel
Sheet: Sheet1

Serial | Project | Event description | Date1 | Date2 | Date3 | TRUE/FALSE | Comments
1502530 | 055504 | 1Delivery | # | # | # | False | False because it has only #
1502530 | 055504 | 2Preparation | # | # | # | False
1502530 | 055504 | 3Assembly | # | # | # | False
1502530 | 055504 | 4Validation | # | # | # | False
1502530 | 055505 | 1Delivery | 2011-07-25 00:00:00 | 2011-07-25 00:00:00 | 2011-07-25 00:00:00 | True | True because all dates filled
1502530 | 055505 | 2Preparation | 2011-07-27 00:00:00 | 2011-07-27 00:00:00 | 2011-07-27 00:00:00 | True
1502530 | 055505 | 3Assembly | 2011-08-10 00:00:00 | 2011-08-10 00:00:00 | 2011-08-10 00:00:00 | True
1502530 | 055505 | 4Validation | 2011-08-30 00:00:00 | 2011-08-30 00:00:00 | 2011-08-30 00:00:00 | True
1502910 | 046340 | 1Delivery | # | # | # | False | Random. Because both 4 lines  has # only
1502910 | 046340 | 2Preparation | # | # | # | False
1502910 | 046340 | 3Assembly | # | # | # | False
1502910 | 046340 | 4Validation | # | # | # | False
1502910 | 047280 | 1Delivery | # | # | # | True | Random. Because both 4 lines  has # only
1502910 | 047280 | 2Preparation | # | # | # | True
1502910 | 047280 | 3Assembly | # | # | # | True
1502910 | 047280 | 4Validation | # | # | # | True
1502936 | 057002 | 1Delivery | 2009-10-01 00:00:00 | 2009-11-07 00:00:00 | 2009-11-07 00:00:00 | False | FALSE because year is earlier 2009v2011
1502936 | 057002 | 2Preparation | 2009-11-07 00:00:00 | 2009-10-01 00:00:00 | 2009-11-07 00:00:00 | False
1502936 | 057002 | 3Assembly | 2009-11-30 00:00:00 | 2009-11-07 00:00:00 | 2009-11-07 00:00:00 | False
1502936 | 057002 | 4Validation | 2009-12-06 00:00:00 | 2009-11-07 00:00:00 | 2009-11-07 00:00:00 | False
1502936 | 072347 | 1Delivery | 2011-10-01 00:00:00 | 2011-10-01 00:00:00 | 2011-10-16 00:00:00 | True | TRUE because year is later 2011v2009
1502936 | 072347 | 2Preparation | 2011-11-07 00:00:00 | 2011-11-07 00:00:00 | 2011-10-16 00:00:00 | True
1502936 | 072347 | 3Assembly | 2011-11-30 00:00:00 | 2011-11-30 00:00:00 | 2011-12-03 00:00:00 | True
1502936 | 072347 | 4Validation | 2011-12-06 00:00:00 | 2012-01-10 00:00:00 | 2011-10-16 00:00:00 | True
1502956 | 064010 | 1Delivery | 2011-12-04 00:00:00 |  | # | False | FALSE because not all dates filled
1502956 | 064010 | 2Preparation | 2011-12-04 00:00:00 |  | # | False
1502956 | 064010 | 3Assembly | 2011-12-04 00:00:00 | 2011-12-18 00:00:00 | # | False
1502956 | 064010 | 4Validation | 2011-12-04 00:00:00 | 2011-12-18 00:00:00 | # | False
1502956 | 078817 | 1Delivery | 2011-12-04 00:00:00 | 2011-12-04 00:00:00 | 2011-12-04 00:00:00 | True | True because all dates filled
1502956 | 078817 | 2Preparation | 2011-12-09 00:00:00 | 2011-12-09 00:00:00 | 2011-12-18 00:00:00 | True
1502956 | 078817 | 3Assembly | 2011-12-31 00:00:00 | 2011-12-31 00:00:00 | 2011-12-31 00:00:00 | True
1502956 | 078817 | 4Validation | 2011-01-13 00:00:00 | 2012-01-17 00:00:00 | 2012-02-28 00:00:00 | True
2120347 | 031789 | 1Delivery | 2008-05-16 00:00:00 | 2009-01-05 00:00:00 | # | False | FALSE  because has less total date entries than next 4 lines, also year is earlier 2009v2011,
2120347 | 031789 | 2Preparation | 2008-05-16 00:00:00 | 2009-01-30 00:00:00 | # | False
2120347 | 031789 | 3Assembly | 2008-05-30 00:00:00 | 2009-02-13 00:00:00 | # | False
2120347 | 031789 | 4Validation | 2008-06-27 00:00:00 | 2009-03-20 00:00:00 | # | False
2120347 | 046898 | 1Delivery | 2010-02-15 00:00:00 | 2010-02-15 00:00:00 | 2011-01-17 00:00:00 | True | TRUE  because has more total date entries than previous 4 lines, also year is later 2011v2009
2120347 | 046898 | 2Preparation | 2010-04-09 00:00:00 | 2010-04-09 00:00:00 | 2011-04-26 00:00:00 | True
2120347 | 046898 | 3Assembly | 2010-05-27 00:00:00 | 2010-05-27 00:00:00 |  | True
2120347 | 046898 | 4Validation | 2010-07-27 00:00:00 | 2011-04-26 00:00:00 |  | True