Count If help?

A

atomictoyguy

New Member
Joined
May 2, 2011
Messages
18
I have a membership spreadsheet that has two sheets of data.

Sheet 1: Member Details
Sheet 2: Transactions

What I would like to do is create a formula that will count the highest consecutive years of membership. I know I can create a count if to find the total number of renewals pretty easily.

On my spreadsheet I can cross reference my members to their transactions using their member ID number. My Transaction sheet contains Transaction Date, ID#, Transaction Type (New, Renew), & Expiration Date.

So basically I only want it to count if the years are consecutive.

The below list should result in a formula value of 11. It shouldn't count the 1996-1997 transaction.

Code: 
[FONT=Lucida Console]4/17/1996    34    NEW      4/17/1997
3/27/1999    34    RENEW    4/17/2000
2/2/2000     34    RENEW    4/17/2001
4/24/2001    34    RENEW    4/17/2002
4/6/2002     34    RENEW    4/17/2003
4/22/2003    34    RENEW    4/17/2004
4/17/2004    34    RENEW    4/17/2005
4/30/2005    34    RENEW    4/17/2006
4/2/2006     34    RENEW    4/17/2007
10/9/2006    34    RENEW    4/17/2008
7/15/2008    34    RENEW    7/15/2009
5/3/2009     34    RENEW    7/15/2010[/FONT]
The reason I want this is I want to implement lifetime memberships for anybody that has reached 10yrs of consecutive membership.
 

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off
Sort by date Sort by votes
atomictoyguy said:
I have a membership spreadsheet that has two sheets of data.

Sheet 1: Member Details
Sheet 2: Transactions

What I would like to do is create a formula that will count the highest consecutive years of membership. I know I can create a count if to find the total number of renewals pretty easily.

On my spreadsheet I can cross reference my members to their transactions using their member ID number. My Transaction sheet contains Transaction Date, ID#, Transaction Type (New, Renew), & Expiration Date.

So basically I only want it to count if the years are consecutive.

The below list should result in a formula value of 11. It shouldn't count the 1996-1997 transaction.

Code: 
[FONT=Lucida Console]4/17/1996    34    NEW      4/17/1997[/FONT]
[FONT=Lucida Console]3/27/1999    34    RENEW    4/17/2000[/FONT]
[FONT=Lucida Console]2/2/2000     34    RENEW    4/17/2001[/FONT]
[FONT=Lucida Console]4/24/2001    34    RENEW    4/17/2002[/FONT]
[FONT=Lucida Console]4/6/2002     34    RENEW    4/17/2003[/FONT]
[FONT=Lucida Console]4/22/2003    34    RENEW    4/17/2004[/FONT]
[FONT=Lucida Console]4/17/2004    34    RENEW    4/17/2005[/FONT]
[FONT=Lucida Console]4/30/2005    34    RENEW    4/17/2006[/FONT]
[FONT=Lucida Console]4/2/2006     34    RENEW    4/17/2007[/FONT]
[FONT=Lucida Console]10/9/2006    34    RENEW    4/17/2008[/FONT]
[FONT=Lucida Console]7/15/2008    34    RENEW    7/15/2009[/FONT]
[FONT=Lucida Console]5/3/2009     34    RENEW    7/15/2010[/FONT]
The reason I want this is I want to implement lifetime memberships for anybody that has reached 10yrs of consecutive membership.
Click to expand...
Maybe something like this:

Book1
ABCD
24/17/199634NEW4/17/1997
33/27/199934RENEW4/17/2000
42/2/200034RENEW4/17/2001
54/24/200134RENEW4/17/2002
64/6/200234RENEW4/17/2003
74/22/200334RENEW4/17/2004
84/17/200434RENEW4/17/2005
94/30/200534RENEW4/17/2006
104/2/200634RENEW4/17/2007
1110/9/200634RENEW4/17/2008
127/15/200834RENEW7/15/2009
135/3/200934RENEW7/15/2010
Sheet1

This array formula**:

=DATEDIF(MIN(IF(B2:B13=34,IF(C2:C13="renew",A2:A13))),MAX(IF(B2:B13=34,IF(C2:C13="renew",D2:D13))),"y")

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.
 
Upvote 0
If I am not mistaken it looks like you are filtering on "Renew". The reason I would need that first date filtered is because it wasn't consecutive, not because it was a "New" member.

Below is another example this example should calculate to 11. Because they were consecutive from 1998 - 2008

<table width="278" border="0" cellpadding="0" cellspacing="0"><colgroup><col style="mso-width-source:userset;mso-width-alt:3181;width:65pt" width="87"> <col style="mso-width-source:userset;mso-width-alt:1609;width:33pt" width="44"> <col style="mso-width-source:userset;mso-width-alt:2742;width:56pt" width="75"> <col style="mso-width-source:userset;mso-width-alt:2633;width:54pt" width="72"> </colgroup><tbody><tr style="height:12.75pt" height="17"> <td class="xl67" style="height:12.75pt;width:65pt" height="17" width="87">8/3/1997</td> <td class="xl65" style="width:33pt" width="44">100</td> <td class="xl64" style="width:56pt" width="75">NEW</td> <td class="xl68" style="width:54pt;font-size:9.0pt; color:#9C0006;font-weight:400;text-decoration:none;text-underline-style:none; text-line-through:none;font-family:Calibri;background:#FFC7CE;mso-pattern: black none" width="72" align="right">8/3/1998</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl67" style="height:12.75pt" height="17">8/9/1998</td> <td class="xl65">100</td> <td class="xl64">RENEW</td> <td class="xl68" style="font-size:9.0pt;color:#9C0006;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;background:#FFC7CE;mso-pattern:black none" align="right">8/3/1999</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl67" style="height:12.75pt" height="17">8/3/1999</td> <td class="xl65">100</td> <td class="xl64">RENEW</td> <td class="xl68" style="font-size:9.0pt;color:#9C0006;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;background:#FFC7CE;mso-pattern:black none" align="right">8/3/2000</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl67" style="height:12.75pt" height="17">7/28/2000</td> <td class="xl65">100</td> <td class="xl64">RENEW</td> <td class="xl68" style="font-size:9.0pt;color:#9C0006;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;background:#FFC7CE;mso-pattern:black none" align="right">8/3/2001</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl67" style="height:12.75pt" height="17">8/6/2001</td> <td class="xl65">100</td> <td class="xl64">RENEW</td> <td class="xl68" style="font-size:9.0pt;color:#9C0006;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;background:#FFC7CE;mso-pattern:black none" align="right">8/3/2002</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl67" style="height:12.75pt" height="17">7/30/2002</td> <td class="xl65">100</td> <td class="xl64">RENEW</td> <td class="xl68" style="font-size:9.0pt;color:#9C0006;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;background:#FFC7CE;mso-pattern:black none" align="right">8/3/2003</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl67" style="height:12.75pt" height="17">9/17/2003</td> <td class="xl65">100</td> <td class="xl64">RENEW</td> <td class="xl68" style="font-size:9.0pt;color:#9C0006;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;background:#FFC7CE;mso-pattern:black none" align="right">8/3/2004</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl67" style="height:12.75pt" height="17">9/23/2004</td> <td class="xl65">100</td> <td class="xl64">RENEW</td> <td class="xl68" style="font-size:9.0pt;color:#9C0006;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;background:#FFC7CE;mso-pattern:black none" align="right">8/3/2005</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl67" style="height:12.75pt" height="17">9/20/2005</td> <td class="xl65">100</td> <td class="xl64">RENEW</td> <td class="xl68" style="font-size:9.0pt;color:#9C0006;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;background:#FFC7CE;mso-pattern:black none" align="right">8/3/2006</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl67" style="height:12.75pt" height="17">8/3/2006</td> <td class="xl65">100</td> <td class="xl64">RENEW</td> <td class="xl68" style="font-size:9.0pt;color:#9C0006;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;background:#FFC7CE;mso-pattern:black none" align="right">8/3/2007</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl67" style="height:12.75pt" height="17">7/11/2007</td> <td class="xl65">100</td> <td class="xl64">RENEW</td> <td class="xl68" style="font-size:9.0pt;color:#9C0006;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;background:#FFC7CE;mso-pattern:black none" align="right">8/3/2008</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl67" style="height:12.75pt" height="17">11/5/2010</td> <td class="xl65">100</td> <td class="xl64">RENEW</td> <td class="xl68" style="font-size:9.0pt;color:#006100;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;background:#C6EFCE;mso-pattern:black none" align="right">11/5/2011</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl67" style="height:12.75pt" height="17">11/5/2010</td> <td class="xl65">100</td> <td class="xl64">RENEW</td> <td class="xl68" style="font-size:9.0pt;color:#006100;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;background:#C6EFCE;mso-pattern:black none" align="right">11/6/2012</td> </tr> </tbody></table>
 
Upvote 0
atomictoyguy said:
If I am not mistaken it looks like you are filtering on "Renew". The reason I would need that first date filtered is because it wasn't consecutive, not because it was a "New" member.

Below is another example this example should calculate to 11. Because they were consecutive from 1998 - 2008

<TABLE cellSpacing=0 cellPadding=0 width=278 border=0><COLGROUP><COL style="WIDTH: 65pt; mso-width-source: userset; mso-width-alt: 3181" width=87><COL style="WIDTH: 33pt; mso-width-source: userset; mso-width-alt: 1609" width=44><COL style="WIDTH: 56pt; mso-width-source: userset; mso-width-alt: 2742" width=75><COL style="WIDTH: 54pt; mso-width-source: userset; mso-width-alt: 2633" width=72></COLGROUP><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD class=xl67 style="WIDTH: 65pt; HEIGHT: 12.75pt" width=87 height=17>8/3/1997</TD><TD class=xl65 style="WIDTH: 33pt" width=44>100</TD><TD class=xl64 style="WIDTH: 56pt" width=75>NEW</TD><TD class=xl68 style="FONT-WEIGHT: 400; FONT-SIZE: 9pt; BACKGROUND: #ffc7ce; WIDTH: 54pt; COLOR: #9c0006; FONT-FAMILY: Calibri; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" align=right width=72>8/3/1998</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl67 style="HEIGHT: 12.75pt" height=17>8/9/1998</TD><TD class=xl65>100</TD><TD class=xl64>RENEW</TD><TD class=xl68 style="FONT-WEIGHT: 400; FONT-SIZE: 9pt; BACKGROUND: #ffc7ce; COLOR: #9c0006; FONT-FAMILY: Calibri; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" align=right>8/3/1999</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl67 style="HEIGHT: 12.75pt" height=17>8/3/1999</TD><TD class=xl65>100</TD><TD class=xl64>RENEW</TD><TD class=xl68 style="FONT-WEIGHT: 400; FONT-SIZE: 9pt; BACKGROUND: #ffc7ce; COLOR: #9c0006; FONT-FAMILY: Calibri; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" align=right>8/3/2000</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl67 style="HEIGHT: 12.75pt" height=17>7/28/2000</TD><TD class=xl65>100</TD><TD class=xl64>RENEW</TD><TD class=xl68 style="FONT-WEIGHT: 400; FONT-SIZE: 9pt; BACKGROUND: #ffc7ce; COLOR: #9c0006; FONT-FAMILY: Calibri; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" align=right>8/3/2001</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl67 style="HEIGHT: 12.75pt" height=17>8/6/2001</TD><TD class=xl65>100</TD><TD class=xl64>RENEW</TD><TD class=xl68 style="FONT-WEIGHT: 400; FONT-SIZE: 9pt; BACKGROUND: #ffc7ce; COLOR: #9c0006; FONT-FAMILY: Calibri; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" align=right>8/3/2002</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl67 style="HEIGHT: 12.75pt" height=17>7/30/2002</TD><TD class=xl65>100</TD><TD class=xl64>RENEW</TD><TD class=xl68 style="FONT-WEIGHT: 400; FONT-SIZE: 9pt; BACKGROUND: #ffc7ce; COLOR: #9c0006; FONT-FAMILY: Calibri; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" align=right>8/3/2003</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl67 style="HEIGHT: 12.75pt" height=17>9/17/2003</TD><TD class=xl65>100</TD><TD class=xl64>RENEW</TD><TD class=xl68 style="FONT-WEIGHT: 400; FONT-SIZE: 9pt; BACKGROUND: #ffc7ce; COLOR: #9c0006; FONT-FAMILY: Calibri; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" align=right>8/3/2004</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl67 style="HEIGHT: 12.75pt" height=17>9/23/2004</TD><TD class=xl65>100</TD><TD class=xl64>RENEW</TD><TD class=xl68 style="FONT-WEIGHT: 400; FONT-SIZE: 9pt; BACKGROUND: #ffc7ce; COLOR: #9c0006; FONT-FAMILY: Calibri; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" align=right>8/3/2005</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl67 style="HEIGHT: 12.75pt" height=17>9/20/2005</TD><TD class=xl65>100</TD><TD class=xl64>RENEW</TD><TD class=xl68 style="FONT-WEIGHT: 400; FONT-SIZE: 9pt; BACKGROUND: #ffc7ce; COLOR: #9c0006; FONT-FAMILY: Calibri; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" align=right>8/3/2006</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl67 style="HEIGHT: 12.75pt" height=17>8/3/2006</TD><TD class=xl65>100</TD><TD class=xl64>RENEW</TD><TD class=xl68 style="FONT-WEIGHT: 400; FONT-SIZE: 9pt; BACKGROUND: #ffc7ce; COLOR: #9c0006; FONT-FAMILY: Calibri; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" align=right>8/3/2007</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl67 style="HEIGHT: 12.75pt" height=17>7/11/2007</TD><TD class=xl65>100</TD><TD class=xl64>RENEW</TD><TD class=xl68 style="FONT-WEIGHT: 400; FONT-SIZE: 9pt; BACKGROUND: #ffc7ce; COLOR: #9c0006; FONT-FAMILY: Calibri; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" align=right>8/3/2008</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl67 style="HEIGHT: 12.75pt" height=17>11/5/2010</TD><TD class=xl65>100</TD><TD class=xl64>RENEW</TD><TD class=xl68 style="FONT-WEIGHT: 400; FONT-SIZE: 9pt; BACKGROUND: #c6efce; COLOR: #006100; FONT-FAMILY: Calibri; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" align=right>11/5/2011</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl67 style="HEIGHT: 12.75pt" height=17>11/5/2010</TD><TD class=xl65>100</TD><TD class=xl64>RENEW</TD><TD class=xl68 style="FONT-WEIGHT: 400; FONT-SIZE: 9pt; BACKGROUND: #c6efce; COLOR: #006100; FONT-FAMILY: Calibri; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" align=right>11/6/2012</TD></TR></TBODY></TABLE>
Click to expand...
OK, I think I understand what you want.

Maybe this...

Array entered**:

=MAX(FREQUENCY(IF(YEAR(D2:D12)+1=YEAR(D3:D13),ROW(D2:D12)),IF(YEAR(D2:D12)+1<>YEAR(D3:D13),ROW(D2:D12))))+1

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.
 
Upvote 0
Ok, sorry for the long delay in getting back to this. Things have been pretty crazy at my work so I haven't had time to poke around at this.

Perhaps I am making this too complicated. Also after some discussion with my board of directors they would prefer it to only count the most recent consecutive years. I believe that could be counted by comparing the expiration years and counting until they stop decrementing by 1.

Here is another the problem the sheet might be sorted by Transaction Date or by ID#. So the formula needs to calculate the correct value regardless of sheet sorting. Maybe Excel just can't do what I need here and I need to step up to access, if so please advise.

I plan on putting this formula on a separate sheet. If I need to upload my spreadsheet to someone to test I would be more than happy to do so, just at the moment I don't see a way to attach to a forum post.

Below is some sample data sorted two different ways. The consecutive years value is what should be returned regardless of sheet sorting.

Sorted by Transaction Date:
<table border="0" cellpadding="0" cellspacing="0" width="349"><colgroup><col style="mso-width-source:userset;mso-width-alt:3181;width:65pt" width="87"> <col style="mso-width-source:userset;mso-width-alt:1609;width:33pt" width="44"> <col style="mso-width-source:userset;mso-width-alt:2742;width:56pt" width="75"> <col style="mso-width-source:userset;mso-width-alt:2633;width:54pt" width="72"> <col style="mso-width-source:userset;mso-width-alt:2596;width:53pt" width="71"> </colgroup><tbody><tr style="mso-height-source:userset;height:26.1pt" height="34"> <td class="xl70" style="height:26.1pt;width:65pt" align="center" height="34" width="87">Transaction Date</td> <td class="xl69" style="width:33pt" align="center" width="44">ID #</td> <td class="xl69" style="width:56pt" align="center" width="75">Transaction Type</td> <td class="xl74" style="width:54pt;font-size:9.0pt;color:#006100; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:Calibri;background:#C6EFCE;mso-pattern:black none" align="center" width="72">Expiration Date</td> <td class="xl68" style="width:53pt" align="center" width="71">Consecutive Years</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl72" style="height:12.75pt" align="center" height="17">8/8/1996</td> <td class="xl66" align="center">57</td> <td class="xl65" align="center">NEW</td> <td class="xl73" style="font-size:9.0pt;color:#9C0006;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;background:#FFC7CE;mso-pattern:black none" align="center">8/8/1997</td> <td class="xl79" align="center">3</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl72" style="height:12.75pt" align="center" height="17">8/3/1997</td> <td class="xl66" align="center">100</td> <td class="xl65" align="center">NEW</td> <td class="xl73" style="font-size:9.0pt;color:#9C0006;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;background:#FFC7CE;mso-pattern:black none" align="center">8/3/1998</td> <td class="xl79" align="center">2</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl72" style="height:12.75pt" align="center" height="17">8/9/1997</td> <td class="xl66" align="center">104</td> <td class="xl65" align="center">NEW</td> <td class="xl73" style="font-size:9.0pt;color:#9C0006;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;background:#FFC7CE;mso-pattern:black none" align="center">8/9/1998</td> <td class="xl79" align="center">14</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl72" style="height:12.75pt" align="center" height="17">9/3/1997</td> <td class="xl66" align="center">57</td> <td class="xl65" align="center">RENEW</td> <td class="xl73" style="font-size:9.0pt;color:#9C0006;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;background:#FFC7CE;mso-pattern:black none" align="center">8/8/1998</td> <td class="xl79" align="center">3</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl72" style="height:12.75pt" align="center" height="17">8/9/1998</td> <td class="xl66" align="center">100</td> <td class="xl65" align="center">RENEW</td> <td class="xl73" style="font-size:9.0pt;color:#9C0006;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;background:#FFC7CE;mso-pattern:black none" align="center">8/3/1999</td> <td class="xl79" align="center">2</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl72" style="height:12.75pt" align="center" height="17">8/20/1998</td> <td class="xl66" align="center">104</td> <td class="xl65" align="center">RENEW</td> <td class="xl73" style="font-size:9.0pt;color:#9C0006;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;background:#FFC7CE;mso-pattern:black none" align="center">8/9/1999</td> <td class="xl79" align="center">14</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl72" style="height:12.75pt" align="center" height="17">9/8/1998</td> <td class="xl66" align="center">57</td> <td class="xl65" align="center">RENEW</td> <td class="xl73" style="font-size:9.0pt;color:#9C0006;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;background:#FFC7CE;mso-pattern:black none" align="center">8/8/1999</td> <td class="xl79" align="center">3</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl72" style="height:12.75pt" align="center" height="17">8/3/1999</td> <td class="xl66" align="center">100</td> <td class="xl65" align="center">RENEW</td> <td class="xl73" style="font-size:9.0pt;color:#9C0006;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;background:#FFC7CE;mso-pattern:black none" align="center">8/3/2000</td> <td class="xl79" align="center">2</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl72" style="height:12.75pt" align="center" height="17">11/21/1999</td> <td class="xl66" align="center">104</td> <td class="xl65" align="center">RENEW</td> <td class="xl73" style="font-size:9.0pt;color:#9C0006;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;background:#FFC7CE;mso-pattern:black none" align="center">8/9/2000</td> <td class="xl79" align="center">14</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl72" style="height:12.75pt" align="center" height="17">7/28/2000</td> <td class="xl66" align="center">100</td> <td class="xl65" align="center">RENEW</td> <td class="xl73" style="font-size:9.0pt;color:#9C0006;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;background:#FFC7CE;mso-pattern:black none" align="center">8/3/2001</td> <td class="xl79" align="center">2</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl72" style="height:12.75pt" align="center" height="17">8/8/2000</td> <td class="xl66" align="center">104</td> <td class="xl65" align="center">RENEW</td> <td class="xl73" style="font-size:9.0pt;color:#9C0006;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;background:#FFC7CE;mso-pattern:black none" align="center">8/9/2001</td> <td class="xl79" align="center">14</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl72" style="height:12.75pt" align="center" height="17">6/13/2001</td> <td class="xl66" align="center">57</td> <td class="xl65" align="center">RENEW</td> <td class="xl73" style="font-size:9.0pt;color:#9C0006;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;background:#FFC7CE;mso-pattern:black none" align="center">6/13/2002</td> <td class="xl79" align="center">3</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl72" style="height:12.75pt" align="center" height="17">8/6/2001</td> <td class="xl66" align="center">100</td> <td class="xl65" align="center">RENEW</td> <td class="xl73" style="font-size:9.0pt;color:#9C0006;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;background:#FFC7CE;mso-pattern:black none" align="center">8/3/2002</td> <td class="xl79" align="center">2</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl72" style="height:12.75pt" align="center" height="17">8/6/2001</td> <td class="xl66" align="center">104</td> <td class="xl65" align="center">RENEW</td> <td class="xl73" style="font-size:9.0pt;color:#9C0006;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;background:#FFC7CE;mso-pattern:black none" align="center">8/9/2002</td> <td class="xl79" align="center">14</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl72" style="height:12.75pt" align="center" height="17">7/30/2002</td> <td class="xl66" align="center">100</td> <td class="xl65" align="center">RENEW</td> <td class="xl73" style="font-size:9.0pt;color:#9C0006;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;background:#FFC7CE;mso-pattern:black none" align="center">8/3/2003</td> <td class="xl79" align="center">2</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl72" style="height:12.75pt" align="center" height="17">8/17/2002</td> <td class="xl66" align="center">104</td> <td class="xl65" align="center">RENEW</td> <td class="xl73" style="font-size:9.0pt;color:#9C0006;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;background:#FFC7CE;mso-pattern:black none" align="center">8/9/2003</td> <td class="xl79" align="center">14</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl72" style="height:12.75pt" align="center" height="17">9/6/2003</td> <td class="xl66" align="center">104</td> <td class="xl65" align="center">RENEW</td> <td class="xl73" style="font-size:9.0pt;color:#9C0006;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;background:#FFC7CE;mso-pattern:black none" align="center">8/9/2004</td> <td class="xl79" align="center">14</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl72" style="height:12.75pt" align="center" height="17">9/17/2003</td> <td class="xl66" align="center">100</td> <td class="xl65" align="center">RENEW</td> <td class="xl73" style="font-size:9.0pt;color:#9C0006;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;background:#FFC7CE;mso-pattern:black none" align="center">8/3/2004</td> <td class="xl79" align="center">2</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl72" style="height:12.75pt" align="center" height="17">9/23/2004</td> <td class="xl66" align="center">100</td> <td class="xl65" align="center">RENEW</td> <td class="xl73" style="font-size:9.0pt;color:#9C0006;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;background:#FFC7CE;mso-pattern:black none" align="center">8/3/2005</td> <td class="xl79" align="center">2</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl72" style="height:12.75pt" align="center" height="17">3/6/2005</td> <td class="xl66" align="center">104</td> <td class="xl65" align="center">RENEW</td> <td class="xl73" style="font-size:9.0pt;color:#9C0006;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;background:#FFC7CE;mso-pattern:black none" align="center">3/6/2006</td> <td class="xl79" align="center">14</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl72" style="height:12.75pt" align="center" height="17">5/6/2005</td> <td class="xl66" align="center">57</td> <td class="xl65" align="center">RENEW</td> <td class="xl73" style="font-size:9.0pt;color:#9C0006;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;background:#FFC7CE;mso-pattern:black none" align="center">5/6/2006</td> <td class="xl79" align="center">3</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl72" style="height:12.75pt" align="center" height="17">9/20/2005</td> <td class="xl66" align="center">100</td> <td class="xl65" align="center">RENEW</td> <td class="xl73" style="font-size:9.0pt;color:#9C0006;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;background:#FFC7CE;mso-pattern:black none" align="center">8/3/2006</td> <td class="xl79" align="center">2</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl72" style="height:12.75pt" align="center" height="17">3/6/2006</td> <td class="xl66" align="center">104</td> <td class="xl65" align="center">RENEW</td> <td class="xl73" style="font-size:9.0pt;color:#9C0006;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;background:#FFC7CE;mso-pattern:black none" align="center">3/6/2007</td> <td class="xl79" align="center">14</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl72" style="height:12.75pt" align="center" height="17">8/3/2006</td> <td class="xl66" align="center">100</td> <td class="xl65" align="center">RENEW</td> <td class="xl73" style="font-size:9.0pt;color:#9C0006;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;background:#FFC7CE;mso-pattern:black none" align="center">8/3/2007</td> <td class="xl79" align="center">2</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl72" style="height:12.75pt" align="center" height="17">4/10/2007</td> <td class="xl66" align="center">104</td> <td class="xl65" align="center">RENEW</td> <td class="xl73" style="font-size:9.0pt;color:#9C0006;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;background:#FFC7CE;mso-pattern:black none" align="center">3/6/2008</td> <td class="xl79" align="center">14</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl72" style="height:12.75pt" align="center" height="17">7/11/2007</td> <td class="xl66" align="center">100</td> <td class="xl65" align="center">RENEW</td> <td class="xl73" style="font-size:9.0pt;color:#9C0006;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;background:#FFC7CE;mso-pattern:black none" align="center">8/3/2008</td> <td class="xl79" align="center">2</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl72" style="height:12.75pt" align="center" height="17">4/1/2008</td> <td class="xl66" align="center">104</td> <td class="xl65" align="center">RENEW</td> <td class="xl73" style="font-size:9.0pt;color:#9C0006;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;background:#FFC7CE;mso-pattern:black none" align="center">3/6/2009</td> <td class="xl79" align="center">14</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl72" style="height:12.75pt" align="center" height="17">5/12/2009</td> <td class="xl66" align="center">57</td> <td class="xl65" align="center">RENEW</td> <td class="xl73" style="font-size:9.0pt;color:#9C0006;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;background:#FFC7CE;mso-pattern:black none" align="center">5/12/2010</td> <td class="xl79" align="center">3</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl72" style="height:12.75pt" align="center" height="17">5/23/2009</td> <td class="xl66" align="center">104</td> <td class="xl65" align="center">RENEW</td> <td class="xl73" style="font-size:9.0pt;color:#9C0006;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;background:#FFC7CE;mso-pattern:black none" align="center">3/6/2010</td> <td class="xl79" align="center">14</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl72" style="height:12.75pt" align="center" height="17">3/7/2010</td> <td class="xl66" align="center">57</td> <td class="xl65" align="center">RENEW</td> <td class="xl73" style="font-size:9.0pt;color:#9C0006;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;background:#FFC7CE;mso-pattern:black none" align="center">5/12/2011</td> <td class="xl79" align="center">3</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl72" style="height:12.75pt" align="center" height="17">5/29/2010</td> <td class="xl66" align="center">104</td> <td class="xl65" align="center">RENEW</td> <td class="xl73" style="font-size:9.0pt;color:#9C0006;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;background:#FFC7CE;mso-pattern:black none" align="center">3/6/2011</td> <td class="xl79" align="center">14</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl72" style="height:12.75pt" align="center" height="17">11/5/2010</td> <td class="xl66" align="center">100</td> <td class="xl65" align="center">RENEW</td> <td class="xl73" style="font-size:9.0pt;color:#006100;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;background:#C6EFCE;mso-pattern:black none" align="center">11/5/2011</td> <td class="xl79" align="center">2</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl72" style="height:12.75pt" align="center" height="17">1/4/2011</td> <td class="xl66" align="center">57</td> <td class="xl65" align="center">RENEW</td> <td class="xl73" style="font-size:9.0pt;color:#006100;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;background:#C6EFCE;mso-pattern:black none" align="center">5/12/2012</td> <td class="xl79" align="center">3</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl72" style="height:12.75pt" align="center" height="17">3/12/2011</td> <td class="xl66" align="center">104</td> <td class="xl65" align="center">RENEW</td> <td class="xl73" style="font-size:9.0pt;color:#006100;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;background:#C6EFCE;mso-pattern:black none" align="center">3/6/2012</td> <td class="xl79" align="center">14</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl72" style="height:12.75pt" align="center" height="17">11/5/2011</td> <td class="xl66" align="center">100</td> <td class="xl65" align="center">RENEW</td> <td class="xl73" style="font-size:9.0pt;color:#006100;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;background:#C6EFCE;mso-pattern:black none" align="center">11/5/2012</td> <td class="xl79" align="center">2</td> </tr> </tbody></table>


Sorted by ID#:
<table border="0" cellpadding="0" cellspacing="0" width="349"><colgroup><col style="mso-width-source:userset;mso-width-alt:3181;width:65pt" width="87"> <col style="mso-width-source:userset;mso-width-alt:1609;width:33pt" width="44"> <col style="mso-width-source:userset;mso-width-alt:2742;width:56pt" width="75"> <col style="mso-width-source:userset;mso-width-alt:2633;width:54pt" width="72"> <col style="mso-width-source:userset;mso-width-alt:2596;width:53pt" width="71"> </colgroup><tbody><tr style="mso-height-source:userset;height:26.1pt" height="34"> <td class="xl70" style="height:26.1pt;width:65pt" align="center" height="34" width="87">Transaction Date</td> <td class="xl69" style="width:33pt" align="center" width="44">ID #</td> <td class="xl69" style="width:56pt" align="center" width="75">Transaction Type</td> <td class="xl74" style="width:54pt;font-size:9.0pt;color:#006100; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:Calibri;background:#C6EFCE;mso-pattern:black none" align="center" width="72">Expiration Date</td> <td class="xl68" style="width:53pt" align="center" width="71">Consecutive Years</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl72" style="height:12.75pt" align="center" height="17">8/8/1996</td> <td class="xl66" align="center">57</td> <td class="xl65" align="center">NEW</td> <td class="xl73" style="font-size:9.0pt;color:#9C0006;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;background:#FFC7CE;mso-pattern:black none" align="center">8/8/1997</td> <td class="xl79" align="center">3</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl72" style="height:12.75pt" align="center" height="17">9/3/1997</td> <td class="xl66" align="center">57</td> <td class="xl65" align="center">RENEW</td> <td class="xl73" style="font-size:9.0pt;color:#9C0006;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;background:#FFC7CE;mso-pattern:black none" align="center">8/8/1998</td> <td class="xl79" align="center">3</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl72" style="height:12.75pt" align="center" height="17">9/8/1998</td> <td class="xl66" align="center">57</td> <td class="xl65" align="center">RENEW</td> <td class="xl73" style="font-size:9.0pt;color:#9C0006;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;background:#FFC7CE;mso-pattern:black none" align="center">8/8/1999</td> <td class="xl79" align="center">3</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl72" style="height:12.75pt" align="center" height="17">6/13/2001</td> <td class="xl66" align="center">57</td> <td class="xl65" align="center">RENEW</td> <td class="xl73" style="font-size:9.0pt;color:#9C0006;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;background:#FFC7CE;mso-pattern:black none" align="center">6/13/2002</td> <td class="xl79" align="center">3</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl72" style="height:12.75pt" align="center" height="17">5/6/2005</td> <td class="xl66" align="center">57</td> <td class="xl65" align="center">RENEW</td> <td class="xl73" style="font-size:9.0pt;color:#9C0006;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;background:#FFC7CE;mso-pattern:black none" align="center">5/6/2006</td> <td class="xl79" align="center">3</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl72" style="height:12.75pt" align="center" height="17">5/12/2009</td> <td class="xl66" align="center">57</td> <td class="xl65" align="center">RENEW</td> <td class="xl73" style="font-size:9.0pt;color:#9C0006;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;background:#FFC7CE;mso-pattern:black none" align="center">5/12/2010</td> <td class="xl79" align="center">3</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl72" style="height:12.75pt" align="center" height="17">3/7/2010</td> <td class="xl66" align="center">57</td> <td class="xl65" align="center">RENEW</td> <td class="xl73" style="font-size:9.0pt;color:#9C0006;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;background:#FFC7CE;mso-pattern:black none" align="center">5/12/2011</td> <td class="xl79" align="center">3</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl72" style="height:12.75pt" align="center" height="17">1/4/2011</td> <td class="xl66" align="center">57</td> <td class="xl65" align="center">RENEW</td> <td class="xl73" style="font-size:9.0pt;color:#006100;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;background:#C6EFCE;mso-pattern:black none" align="center">5/12/2012</td> <td class="xl79" align="center">3</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl72" style="height:12.75pt" align="center" height="17">8/3/1997</td> <td class="xl66" align="center">100</td> <td class="xl65" align="center">NEW</td> <td class="xl73" style="font-size:9.0pt;color:#9C0006;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;background:#FFC7CE;mso-pattern:black none" align="center">8/3/1998</td> <td class="xl79" align="center">2</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl72" style="height:12.75pt" align="center" height="17">8/9/1998</td> <td class="xl66" align="center">100</td> <td class="xl65" align="center">RENEW</td> <td class="xl73" style="font-size:9.0pt;color:#9C0006;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;background:#FFC7CE;mso-pattern:black none" align="center">8/3/1999</td> <td class="xl79" align="center">2</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl72" style="height:12.75pt" align="center" height="17">8/3/1999</td> <td class="xl66" align="center">100</td> <td class="xl65" align="center">RENEW</td> <td class="xl73" style="font-size:9.0pt;color:#9C0006;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;background:#FFC7CE;mso-pattern:black none" align="center">8/3/2000</td> <td class="xl79" align="center">2</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl72" style="height:12.75pt" align="center" height="17">7/28/2000</td> <td class="xl66" align="center">100</td> <td class="xl65" align="center">RENEW</td> <td class="xl73" style="font-size:9.0pt;color:#9C0006;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;background:#FFC7CE;mso-pattern:black none" align="center">8/3/2001</td> <td class="xl79" align="center">2</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl72" style="height:12.75pt" align="center" height="17">8/6/2001</td> <td class="xl66" align="center">100</td> <td class="xl65" align="center">RENEW</td> <td class="xl73" style="font-size:9.0pt;color:#9C0006;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;background:#FFC7CE;mso-pattern:black none" align="center">8/3/2002</td> <td class="xl79" align="center">2</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl72" style="height:12.75pt" align="center" height="17">7/30/2002</td> <td class="xl66" align="center">100</td> <td class="xl65" align="center">RENEW</td> <td class="xl73" style="font-size:9.0pt;color:#9C0006;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;background:#FFC7CE;mso-pattern:black none" align="center">8/3/2003</td> <td class="xl79" align="center">2</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl72" style="height:12.75pt" align="center" height="17">9/17/2003</td> <td class="xl66" align="center">100</td> <td class="xl65" align="center">RENEW</td> <td class="xl73" style="font-size:9.0pt;color:#9C0006;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;background:#FFC7CE;mso-pattern:black none" align="center">8/3/2004</td> <td class="xl79" align="center">2</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl72" style="height:12.75pt" align="center" height="17">9/23/2004</td> <td class="xl66" align="center">100</td> <td class="xl65" align="center">RENEW</td> <td class="xl73" style="font-size:9.0pt;color:#9C0006;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;background:#FFC7CE;mso-pattern:black none" align="center">8/3/2005</td> <td class="xl79" align="center">2</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl72" style="height:12.75pt" align="center" height="17">9/20/2005</td> <td class="xl66" align="center">100</td> <td class="xl65" align="center">RENEW</td> <td class="xl73" style="font-size:9.0pt;color:#9C0006;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;background:#FFC7CE;mso-pattern:black none" align="center">8/3/2006</td> <td class="xl79" align="center">2</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl72" style="height:12.75pt" align="center" height="17">8/3/2006</td> <td class="xl66" align="center">100</td> <td class="xl65" align="center">RENEW</td> <td class="xl73" style="font-size:9.0pt;color:#9C0006;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;background:#FFC7CE;mso-pattern:black none" align="center">8/3/2007</td> <td class="xl79" align="center">2</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl72" style="height:12.75pt" align="center" height="17">7/11/2007</td> <td class="xl66" align="center">100</td> <td class="xl65" align="center">RENEW</td> <td class="xl73" style="font-size:9.0pt;color:#9C0006;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;background:#FFC7CE;mso-pattern:black none" align="center">8/3/2008</td> <td class="xl79" align="center">2</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl72" style="height:12.75pt" align="center" height="17">11/5/2010</td> <td class="xl66" align="center">100</td> <td class="xl65" align="center">RENEW</td> <td class="xl73" style="font-size:9.0pt;color:#006100;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;background:#C6EFCE;mso-pattern:black none" align="center">11/5/2011</td> <td class="xl79" align="center">2</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl72" style="height:12.75pt" align="center" height="17">11/5/2011</td> <td class="xl66" align="center">100</td> <td class="xl65" align="center">RENEW</td> <td class="xl73" style="font-size:9.0pt;color:#006100;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;background:#C6EFCE;mso-pattern:black none" align="center">11/5/2012</td> <td class="xl79" align="center">2</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl72" style="height:12.75pt" align="center" height="17">8/9/1997</td> <td class="xl66" align="center">104</td> <td class="xl65" align="center">NEW</td> <td class="xl73" style="font-size:9.0pt;color:#9C0006;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;background:#FFC7CE;mso-pattern:black none" align="center">8/9/1998</td> <td class="xl79" align="center">14</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl72" style="height:12.75pt" align="center" height="17">8/20/1998</td> <td class="xl66" align="center">104</td> <td class="xl65" align="center">RENEW</td> <td class="xl73" style="font-size:9.0pt;color:#9C0006;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;background:#FFC7CE;mso-pattern:black none" align="center">8/9/1999</td> <td class="xl79" align="center">14</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl72" style="height:12.75pt" align="center" height="17">11/21/1999</td> <td class="xl66" align="center">104</td> <td class="xl65" align="center">RENEW</td> <td class="xl73" style="font-size:9.0pt;color:#9C0006;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;background:#FFC7CE;mso-pattern:black none" align="center">8/9/2000</td> <td class="xl79" align="center">14</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl72" style="height:12.75pt" align="center" height="17">8/8/2000</td> <td class="xl66" align="center">104</td> <td class="xl65" align="center">RENEW</td> <td class="xl73" style="font-size:9.0pt;color:#9C0006;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;background:#FFC7CE;mso-pattern:black none" align="center">8/9/2001</td> <td class="xl79" align="center">14</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl72" style="height:12.75pt" align="center" height="17">8/6/2001</td> <td class="xl66" align="center">104</td> <td class="xl65" align="center">RENEW</td> <td class="xl73" style="font-size:9.0pt;color:#9C0006;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;background:#FFC7CE;mso-pattern:black none" align="center">8/9/2002</td> <td class="xl79" align="center">14</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl72" style="height:12.75pt" align="center" height="17">8/17/2002</td> <td class="xl66" align="center">104</td> <td class="xl65" align="center">RENEW</td> <td class="xl73" style="font-size:9.0pt;color:#9C0006;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;background:#FFC7CE;mso-pattern:black none" align="center">8/9/2003</td> <td class="xl79" align="center">14</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl72" style="height:12.75pt" align="center" height="17">9/6/2003</td> <td class="xl66" align="center">104</td> <td class="xl65" align="center">RENEW</td> <td class="xl73" style="font-size:9.0pt;color:#9C0006;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;background:#FFC7CE;mso-pattern:black none" align="center">8/9/2004</td> <td class="xl79" align="center">14</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl72" style="height:12.75pt" align="center" height="17">3/6/2005</td> <td class="xl66" align="center">104</td> <td class="xl65" align="center">RENEW</td> <td class="xl73" style="font-size:9.0pt;color:#9C0006;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;background:#FFC7CE;mso-pattern:black none" align="center">3/6/2006</td> <td class="xl79" align="center">14</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl72" style="height:12.75pt" align="center" height="17">3/6/2006</td> <td class="xl66" align="center">104</td> <td class="xl65" align="center">RENEW</td> <td class="xl73" style="font-size:9.0pt;color:#9C0006;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;background:#FFC7CE;mso-pattern:black none" align="center">3/6/2007</td> <td class="xl79" align="center">14</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl72" style="height:12.75pt" align="center" height="17">4/10/2007</td> <td class="xl66" align="center">104</td> <td class="xl65" align="center">RENEW</td> <td class="xl73" style="font-size:9.0pt;color:#9C0006;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;background:#FFC7CE;mso-pattern:black none" align="center">3/6/2008</td> <td class="xl79" align="center">14</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl72" style="height:12.75pt" align="center" height="17">4/1/2008</td> <td class="xl66" align="center">104</td> <td class="xl65" align="center">RENEW</td> <td class="xl73" style="font-size:9.0pt;color:#9C0006;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;background:#FFC7CE;mso-pattern:black none" align="center">3/6/2009</td> <td class="xl79" align="center">14</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl72" style="height:12.75pt" align="center" height="17">5/23/2009</td> <td class="xl66" align="center">104</td> <td class="xl65" align="center">RENEW</td> <td class="xl73" style="font-size:9.0pt;color:#9C0006;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;background:#FFC7CE;mso-pattern:black none" align="center">3/6/2010</td> <td class="xl79" align="center">14</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl72" style="height:12.75pt" align="center" height="17">5/29/2010</td> <td class="xl66" align="center">104</td> <td class="xl65" align="center">RENEW</td> <td class="xl73" style="font-size:9.0pt;color:#9C0006;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;background:#FFC7CE;mso-pattern:black none" align="center">3/6/2011</td> <td class="xl79" align="center">14</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl72" style="height:12.75pt" align="center" height="17">3/12/2011</td> <td class="xl66" align="center">104</td> <td class="xl65" align="center">RENEW</td> <td class="xl73" style="font-size:9.0pt;color:#006100;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;background:#C6EFCE;mso-pattern:black none" align="center">3/6/2012</td> <td class="xl79" align="center">14</td> </tr> </tbody></table>
 
Upvote 0
You must log in or register to reply here.

Similar threads

L
  • Solved
Help Please
2 3
Replies
21
Views
517
Asbestos_Jen
Asbestos_Jen
G
  • Question Question
Help me with this!
Replies
1
Views
353
bobaol
B
R
  • Solved
Age Group Ranging by gender
Replies
2
Views
274
Raj1979
R
J
  • Question Question
Count number of screws
Replies
2
Views
173
Fluff
Fluff
V
  • Solved
Dynamic arrays, circular arguments and all I want to due is increment a previous number
Replies
3
Views
112
djclements
djclements

Forum statistics

Threads
1,224,550
Messages
6,179,462
Members
452,915
Latest member
hannnahheileen

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top