Spreadsheet: 84569d1284620861-conditional-input-in-a-cell-based-on-data-in-two-different-cells-and-other-values-trial
Sheet: Sheet2

Director ID | Transaction Date | Year | Total Holdings | Last holding of the year
1 | 31-Mar-1993 | 1993 | 12509
1 | 30-Mar-1993 | 1993 | 10909
1 | 25-Jul-1995 | 1995 | 25287
1 | 19-Sep-1995 | 1995 | 88282
1 | 19-Sep-1995 | 1995 | 25282
1 | 11-Aug-1993 | 1993 | 13859
1 | 08-Aug-1996 | 1996 | 25667
1 | 07-Oct-1996 | 1996 | 12645
1 | 07-Oct-1996 | 1996 | 11851
1 | 04-Feb-1994 | 1994 | 83834
1 | 04-Feb-1994 | 1994 | 48834
1 | 04-Feb-1994 | 1994 | 23834
1 | 04-Aug-1994 | 1994 | 24551
2 | 27-Aug-1991 | 1991 | 0
3 | 22-Dec-2004 | 2004 | 10194
3 | 22-Dec-2004 | 2004 | 20194
3 | 20-Jan-1997 | 1997 | 6322
3 | 18-Mar-2005 | 2005 | 10194
3 | 18-Mar-2005 | 2005 | 30194
3 | 14-Dec-2004 | 2004 | 10194
3 | 14-Dec-2004 | 2004 | 35194
4 | 24-Apr-2007 | 2007 | 35000
4 | 23-Mar-2005 | 2005 | 0
4 | 23-Apr-2007 | 2007 | 25000
4 | 10-Jun-2002 | 2002 | 7000
4 | 04-Jun-2004 | 2004 | 15000
4 | 04-Jul-2005 | 2005 | 15000
5 | 27-May-2010 | 2010 | 88010
5 | 26-Nov-2008 | 2008 | 60642
5 | 25-Nov-2008 | 2008 | 46400
5 | 25-May-2007 | 2007 | 25389
5 | 25-Mar-2008 | 2008 | 34398
5 | 25-Mar-2008 | 2008 | 27398
5 | 24-Aug-2009 | 2009 | 92104
5 | 24-Aug-2009 | 2009 | 75000
5 | 23-Mar-2007 | 2007 | 16271
5 | 22-Mar-2006 | 2006 | 11337
5 | 19-Mar-2003 | 2003 | 3150
5 | 18-Mar-2005 | 2005 | 8929
5 | 09-Jun-2009 | 2009 | 70000
5 | 09-Jun-2009 | 2009 | 95485
5 | 07-Apr-2006 | 2006 | 14017
5 | 03-Dec-2007 | 2007 | 25467
5 | 01-Dec-2006 | 2006 | 14623
6 | 21-Sep-1994 | 1994 | 5344000
6 | 11-Jul-1996 | 1996 | 4979000
7 | 28-May-2004 | 2004 | 42350
7 | 27-Nov-2008 | 2008 | 2597832
7 | 26-Nov-2008 | 2008 | 2567832
7 | 25-May-2005 | 2005 | 10175
7 | 19-Aug-2009 | 2009 | 2374320
7 | 15-Aug-2000 | 2000 | 105843
7 | 09-Oct-2009 | 2009 | 405000
7 | 03-Aug-2001 | 2001 | 2122832
7 | 02-Jun-1999 | 1999 | 32175
8 | 31-Oct-1991 | 1991 | 3151542
8 | 28-Oct-1991 | 1991 | 3156792
8 | 28-Oct-1991 | 1991 | 3176542
8 | 28-Oct-1991 | 1991 | 3164042
8 | 28-Oct-1991 | 1991 | 3211542
8 | 26-May-2005 | 2005 | 2098360
8 | 25-Jul-1995 | 1995 | 3114345
8 | 19-Sep-1995 | 1995 | 3102759
8 | 19-Sep-1995 | 1995 | 3152759
8 | 19-Sep-1995 | 1995 | 3187759
8 | 11-Aug-1993 | 1993 | 3112892
8 | 08-Aug-1996 | 1996 | 3103144
8 | 07-Apr-1998 | 1998 | 3013144
8 | 04-Aug-1994 | 1994 | 3113609
8 | 03-Aug-2001 | 2001 | 2257798
9 | 22-Nov-1991 | 1991 | 4000
9 | 11-Nov-1992 | 1992 | 9488
9 | 08-Oct-1993 | 1993 | 1488
10 | 28-Sep-2001 | 2001 | 24651
10 | 28-Aug-1991 | 1991 | 0
10 | 27-Jul-2000 | 2000 | 16651
10 | 25-Jul-1995 | 1995 | 6964
10 | 19-Sep-1995 | 1995 | 6964
10 | 19-Sep-1995 | 1995 | 56964
10 | 19-Mar-2003 | 2003 | 30987
10 | 17-Oct-1996 | 1996 | 7327
10 | 17-Oct-1996 | 1996 | 6544
10 | 12-Aug-1998 | 1998 | 14166
10 | 11-Aug-1993 | 1993 | 5511
10 | 08-Sep-1997 | 1997 | 7427
10 | 08-Aug-1996 | 1996 | 7349
10 | 07-Apr-1998 | 1998 | 12427
10 | 04-Aug-1994 | 1994 | 6228
10 | 02-Apr-1993 | 1993 | 4161
11 | 07-Dec-2009 | 2009 | 11108
12 | 28-Oct-1996 | 1996 | 26617
12 | 28-Oct-1996 | 1996 | 17894
12 | 25-Jul-1995 | 1995 | 11232
12 | 20-Feb-1995 | 1995 | 10496
12 | 11-Aug-1993 | 1993 | 10671
12 | 08-Aug-1996 | 1996 | 11617
12 | 07-Apr-1993 | 1993 | 12520
12 | 06-Apr-1993 | 1993 | 27020
12 | 04-Aug-1994 | 1994 | 11388
12 | 01-May-1992 | 1992 | 8121
12 | 01-Apr-1993 | 1993 | 33121
12 | 01-Apr-1993 | 1993 | 30021
13 | 30-Dec-1998 | 1998 | 2506170
13 | 26-Jul-2001 | 2001 | 2471886
13 | 26-Jul-2001 | 2001 | 259286
13 | 21-Sep-1994 | 1994 | 2019000
13 | 21-Jul-1992 | 1992 | 2599000
13 | 12-Mar-1993 | 1993 | 2399000
13 | 11-Mar-1993 | 1993 | 2599000
13 | 11-Mar-1993 | 1993 | 2349000
13 | 10-Mar-1993 | 1993 | 500000
13 | 10-Mar-1993 | 1993 | 1050000
13 | 10-Mar-1993 | 1993 | 2099000
13 | 05-Oct-1994 | 1994 | 514303
13 | 05-Oct-1994 | 1994 | 2026151
14 | 23-Mar-1999 | 1999 | 8650
14 | 09-Mar-1993 | 1993 | 1000
14 | 07-Apr-1998 | 1998 | 6500
14 | 04-May-1993 | 1993 | 1500
15 | 13-Nov-2008 | 2008 | 60000
16 | 30-Apr-1996 | 1996 | 6646
16 | 30-Apr-1996 | 1996 | 5634
16 | 25-Jul-1995 | 1995 | 6678
16 | 22-Aug-1995 | 1995 | 5678
16 | 22-Aug-1995 | 1995 | 6662
16 | 19-Sep-1995 | 1995 | 6662
16 | 19-Sep-1995 | 1995 | 56662
16 | 11-Aug-1993 | 1993 | 5243
16 | 08-Aug-1996 | 1996 | 7031
16 | 04-Aug-1994 | 1994 | 5960
16 | 02-Mar-1995 | 1995 | 5942
16 | 02-Mar-1995 | 1995 | 4778
17 | 19-Aug-1999 | 1999 | 3000
18 | 28-Sep-2001 | 2001 | 13315
18 | 25-Jul-2000 | 2000 | 6315
18 | 18-Mar-2003 | 2003 | 20501
18 | 11-Aug-2000 | 2000 | 9315
19 | 20-Mar-2002 | 2002 | 4000
19 | 13-Nov-2008 | 2008 | 14000
19 | 07-Apr-1998 | 1998 | 2000
20 | 10-Apr-1996 | 1996 | 1000
21 | 28-May-2008 | 2008 | 5324
21 | 20-Nov-2008 | 2008 | 15055
21 | 12-Mar-2009 | 2009 | 25055