Hello!
I need a formula that will return the following in the Consecutive Years Given column. Any help is greatly appreciated.
[TABLE="border: 0, cellpadding: 0, cellspacing: 0"]
[TD="width: 147"]A[/TD]
[TD="width: 71"]B[/TD]
[TD="width: 79"]C[/TD]
[TD="width: 71"]D[/TD]
[TD="width: 71"]E[/TD]
[TD="width: 79"]F[/TD]
[TD="width: 71"]G[/TD]
[TD="width: 71"]H[/TD]
[TD="width: 147"]Donor[/TD]
[TD="width: 71, align: right"]2017[/TD]
[TD="width: 79, align: right"]2016[/TD]
[TD="width: 71, align: right"]2015[/TD]
[TD="width: 71, align: right"]2014[/TD]
[TD="width: 79, align: right"]2013[/TD]
[TD="width: 71, align: right"]2012[/TD]
[TD="width: 71, align: right"]Consecutive Years Given[/TD]
[TD="width: 147"]Test[/TD]
[TD="width: 71, align: right"]100[/TD]
[TD="width: 79, align: right"]0[/TD]
[TD="width: 71, align: right"]100[/TD]
[TD="width: 71, align: right"]100[/TD]
[TD="width: 79, align: right"]100[/TD]
[TD="width: 71, align: right"]0[/TD]
[TD="width: 71, align: right"]3[/TD]
Test
[/td]
[TD="align: right"]100[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]2[/TD]
Test
[/td]
[TD="align: right"]100[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]2[/TD]
Test
[/td]
[TD="align: right"]100[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]2[/TD]
Test
[/td]
[TD="align: right"]50[/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]6[/TD]
Test
[/td]
[TD="align: right"]50[/TD]
[TD="align: right"]505[/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4[/TD]
[/TABLE]