Spreadsheet: 155460d1336853705-copy-value-on-condition-example_12may_fixed
Sheet: Sheet2

ID_firm | ID_manager | full_date | proxy | year | The latest record for each manager*firm*year combination | copy the oldest
 | 24013 | 2003-07-03 00:00:00 | 5.73344 |  | 0 | 0
 | 24013 | 2003-07-03 00:00:00 | 5.73344 |  | 1 | 5.73344
 | 24013 | 2007-01-30 00:00:00 | 5.302824 |  | 0 | 0
 | 24013 | 2007-01-30 00:00:00 | 5.302824 |  | 1 | 5.302824
 | 70596 | 2009-11-25 00:00:00 | 0.058642 |  | 0 | 0
 | 70596 | 2010-08-02 00:00:00 | 0.10601 |  | 1 | 0.10601
 | 71099 | 2006-05-31 00:00:00 | 0.151648 |  | 1 | 0.151648
 | 71099 | 2006-12-27 00:00:00 | 0.303044 |  | 0 | 0
 | 71099 | 2007-06-29 00:00:00 | 0.386065 |  | 1 | 0.386065
 | 71099 | 2008-03-20 00:00:00 | 0.499614 |  | 0 | 0
 | 71099 | 2008-07-07 00:00:00 | 0.651012 |  | 1 | 0.651012
 | 71099 | 2009-03-23 00:00:00 | 1.485599 |  | 1 | 1.485599
 | 29337 | 2001-06-07 00:00:00 | 1.729187 |  | 1 | 1.729187
 | 29337 | 2007-11-02 00:00:00 | 0.619273 |  | 1 | 0.619273
 | 29337 | 2008-01-23 00:00:00 | 0.733854 |  | 1 | 0.733854
 | 30017 | 2007-11-02 00:00:00 | 0.827762 |  | 0 | 0
 | 49288 | 2005-09-28 00:00:00 | 0.421533 |  | 1 | 0.421533
 | 49288 | 2007-08-30 00:00:00 | 0.505253 |  | 1 | 0.505253
 | 49288 | 2008-07-01 00:00:00 | 0.714555 |  | 1 | 0.714555
 | 67756 | 2005-09-28 00:00:00 | 14.6511 |  | 0 | 0
 | 67756 | 2005-09-28 00:00:00 | 14.6511 |  | 1 | 14.6511
 | 20949 | 2001-12-06 00:00:00 | 0.368846 |  | 1 | 0.368846
 | 20949 | 2002-07-18 00:00:00 | 0.382681 |  | 1 | 0.382681
 | 20949 | 2003-02-03 00:00:00 | 0.391174 |  | 0 | 0
 | 20949 | 2003-07-25 00:00:00 | 0.389627 |  | 1 | 0.389627
 | 20949 | 2004-07-30 00:00:00 | 0.423115 |  | 1 | 0.423115
 | 81852 | 2010-03-24 00:00:00 | 0.039019 |  | 1 | 0.039019
 | 89725 | 2010-03-24 00:00:00 | 0.058529 |  | 0 | 0
 | 89725 | 2010-03-25 00:00:00 | 0.156076 |  | 1 | 0.156076
 | 27440 | 2000-11-29 00:00:00 | 4.408118 |  | 1 | 4.408118
 | 48631 | 2009-07-10 00:00:00 | 0.044739 |  | 1 | 0.044739
 | 54868 | 2000-09-27 00:00:00 | 0.027928 |  | 1 | 0.027928
 | 54868 | 2002-08-19 00:00:00 | 0.041337 |  | 1 | 0.041337
 | 54868 | 2004-09-21 00:00:00 | 0.181976 |  | 1 | 0.181976
 | 54868 | 2005-07-15 00:00:00 | 0.19622 |  | 1 | 0.19622
 | 54868 | 2006-06-30 00:00:00 | 0.197371 |  | 1 | 0.197371
 | 54868 | 2007-07-04 00:00:00 | 0.30723 |  | 1 | 0.30723
 | 64898 | 2006-06-30 00:00:00 | 0.238125 |  | 1 | 0.238125
 | 64898 | 2007-07-04 00:00:00 | 0.414558 |  | 1 | 0.414558
 | 64898 | 2008-07-01 00:00:00 | 0.492022 |  | 1 | 0.492022
 | 64898 | 2009-01-27 00:00:00 | 0.520784 |  | 1 | 0.520784
 | 64898 | 2009-02-10 00:00:00 | 0.539198 |  | 1 | 0.539198
 | 64898 | 2009-07-10 00:00:00 | 0.115966 |  | 1 | 0.115966
 | 56809 | 2002-06-21 00:00:00 | 0.050463 |  | 1 | 0.050463
 | 37364 | 2005-01-31 00:00:00 | 0.098223 |  | 0 | 0
 | 37364 | 2005-02-28 00:00:00 | 0.098381 |  | 0 | 0
 | 37364 | 2005-03-31 00:00:00 | 0.098542 |  | 0 | 0
 | 37364 | 2005-04-15 00:00:00 | 0.282604 |  | 0 | 0
 | 37364 | 2005-04-29 00:00:00 | 0.282744 |  | 0 | 0
 | 37364 | 2005-07-29 00:00:00 | 0.28193 |  | 0 | 0
 | 37364 | 2005-08-01 00:00:00 | 0.281973 |  | 0 | 0
 | 37364 | 2005-08-31 00:00:00 | 0.282084 |  | 0 | 0
 | 37364 | 2005-09-30 00:00:00 | 0.28221 |  | 0 | 0
 | 37364 | 2005-10-31 00:00:00 | 0.282424 |  | 0 | 0
 | 37364 | 2005-11-30 00:00:00 | 0.28233 |  | 0 | 0
 | 37364 | 2005-12-22 00:00:00 | 0.282453 |  | 1 | 0.282453
 | 37364 | 2006-02-28 00:00:00 | 0.282691 |  | 0 | 0
 | 37364 | 2006-04-28 00:00:00 | 0.282897 |  | 0 | 0
 | 37364 | 2006-05-30 00:00:00 | 0.283167 |  | 0 | 0
 | 37364 | 2006-07-31 00:00:00 | 0.257738 |  | 0 | 0
 | 37364 | 2006-08-31 00:00:00 | 0.257902 |  | 0 | 0
 | 37364 | 2006-09-29 00:00:00 | 0.258062 |  | 0 | 0
 | 37364 | 2006-10-31 00:00:00 | 0.258221 |  | 0 | 0
 | 37364 | 2006-11-30 00:00:00 | 0.258393 |  | 0 | 0
 | 37364 | 2006-12-06 00:00:00 | 0.273514 |  | 1 | 0.273514
 | 37364 | 2007-01-02 00:00:00 | 0.103079 |  | 0 | 0
 | 37364 | 2007-01-31 00:00:00 | 0.103299 |  | 0 | 0
 | 37364 | 2007-02-28 00:00:00 | 0.103072 |  | 0 | 0
 | 37364 | 2007-03-30 00:00:00 | 0.103303 |  | 0 | 0
 | 37364 | 2007-04-30 00:00:00 | 0.103496 |  | 0 | 0
 | 37364 | 2007-05-31 00:00:00 | 0.103685 |  | 0 | 0
 | 37364 | 2007-06-29 00:00:00 | 0.103947 |  | 0 | 0
 | 37364 | 2007-08-01 00:00:00 | 0.104296 |  | 0 | 0
 | 37364 | 2007-08-31 00:00:00 | 0.104594 |  | 0 | 0
 | 37364 | 2007-09-28 00:00:00 | 0.105451 |  | 0 | 0
 | 37364 | 2007-10-31 00:00:00 | 0.10587 |  | 0 | 0
 | 37364 | 2007-11-30 00:00:00 | 0.151732 |  | 1 | 0.151732
 | 37364 | 2008-01-02 00:00:00 | 0.062636 |  | 0 | 0
 | 37364 | 2008-01-31 00:00:00 | 0.062861 |  | 0 | 0
 | 37364 | 2008-02-29 00:00:00 | 0.103132 |  | 0 | 0
 | 37364 | 2008-03-31 00:00:00 | 0.103446 |  | 0 | 0
 | 37364 | 2008-04-30 00:00:00 | 0.103807 |  | 0 | 0
 | 37364 | 2008-05-30 00:00:00 | 0.104161 |  | 0 | 0
 | 37364 | 2008-06-30 00:00:00 | 0.104478 |  | 0 | 0
 | 37364 | 2008-07-31 00:00:00 | 0.104837 |  | 0 | 0
 | 37364 | 2008-08-29 00:00:00 | 0.105123 |  | 1 | 0.105123
 | 37364 | 2010-05-28 00:00:00 | 0.118725 |  | 1 | 0.118725
 | 46980 | 2000-05-26 00:00:00 | 1.991151 |  | 1 | 1.991151
 | 46980 | 2002-02-26 00:00:00 | 1.186942 |  | 1 | 1.186942
 | 46980 | 2004-07-30 00:00:00 | 1.040823 |  | 1 | 1.040823
 | 46980 | 2005-01-31 00:00:00 | 1.057705 |  | 0 | 0
 | 46980 | 2005-02-28 00:00:00 | 1.057863 |  | 0 | 0
 | 46980 | 2005-03-31 00:00:00 | 1.058024 |  | 0 | 0
 | 46980 | 2005-04-15 00:00:00 | 1.26739 |  | 0 | 0
 | 46980 | 2005-04-29 00:00:00 | 1.26753 |  | 0 | 0
 | 46980 | 2005-07-29 00:00:00 | 1.26337 |  | 0 | 0
 | 46980 | 2005-08-01 00:00:00 | 1.263413 |  | 0 | 0
 | 46980 | 2005-08-31 00:00:00 | 1.263524 |  | 0 | 0
 | 46980 | 2005-09-30 00:00:00 | 1.263651 |  | 1 | 1.263651