Earliest/Latest Calendar Day

joferder · Aug 24, 2011

I have a spreadsheet that lists the earliest and latest day that snow fell each year. The Earliest date is listed in column "R" and the Latest in column "T. The rest of the spreadsheet is set up so that I can in put a start date and an end date and it will only give me the applicable data between the two. It does this by eliminating the irrelavent data in the next colum to the right ("S" for earliest and "U" for the latest), which works perfectly for what I need it to do.

The problem that I am having is getting excel to find the earliest date in the column S (range S5:S489) and the latest date in column U (range U5:U489) without taking year into consideration. I want it to show me that the earliest date in the range is 13 October 2011 and not 29 October 2005 since it is the earliest in the range. I have tried going with a simple "=MIN(S5:S489)" (and "=MAX(U5:U489)" for the latest date), but all that shows me is the earliest date based off of year.

This is one of the last things I need to fix on this spreadsheet and the solution has been eluding me for some time now. Any suggestions and ideas are greatly appreciated. If there is anything that I need to clarrify on, please let me know and I will do what I can so that a solution can be reached.

Thanks in advance for any and all help with this.

v/r,

John

joferder · Sep 7, 2011

Sorry that it has taken me so long to reply back. I am working nights now and so I haven't had a lot of time to work on this.

Below is a shortened version of spreadsheet I posted before. With the information below, the data in cell C2 should come up with a date of 26-Oct-88 instead of 25-Nov-90. For cell D2, the propper information should be 12-May-91 instead of 30-Apr-90.

I want cell C2 to come up with the earliest date in the range, without taking into consideration the year (within the range). Cell D2 is the same idea but the latest calendar date.

I am currently using the following formula for the Earliest Snowfall:

=INDEX($C$6:$C$48,MATCH(MIN(IF($C$6:$C$48>=A2,IF($C$6:$C$48<=B2,DAY($C$6:$C$48)))),IF($C$6:$C$48>=A2,IF($C$6:$C$48<=B2,DAY($C$6:$C$48))),0))

From what I can figure out it only looks at the day without considering the month. I'm sure that there is a way to add the month into the equation, but I don't know how to do it. Any advice is greatly appreciated.

Here is the spreadsheet:

<TABLE style="WIDTH: 440pt; BORDER-COLLAPSE: collapse; TABLE-LAYOUT: fixed" border=0 cellSpacing=0 cellPadding=0 width=586><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="WIDTH: 125pt; HEIGHT: 15pt" class=xl705995 height=20 width=167>ARRIVED </TD><TD style="BORDER-LEFT: medium none; WIDTH: 80pt" class=xl715995 width=107>Departure</TD><TD style="BORDER-LEFT: medium none" class=xl715995 width=0>MAX TEMP</TD><TD style="BORDER-LEFT: medium none" class=xl715995 width=0></TD><TD style="BORDER-LEFT: medium none" class=xl715995 width=0>MIN TEMP</TD><TD style="BORDER-LEFT: medium none" class=xl715995 width=0></TD><TD style="BORDER-LEFT: medium none" class=xl715995 width=0>MAX WIND</TD><TD style="BORDER-LEFT: medium none" class=xl715995 width=0></TD><TD style="BORDER-LEFT: medium none" class=xl715995 width=0>T-STORMS</TD><TD style="BORDER-LEFT: medium none" class=xl715995 width=0></TD><TD style="BORDER-LEFT: medium none" class=xl715995 width=0>SNOWFALL</TD><TD style="BORDER-LEFT: medium none" class=xl715995 width=0></TD><TD style="BORDER-LEFT: medium none" class=xl715995 width=0>BELOW 0°F</TD><TD style="BORDER-LEFT: medium none" class=xl715995 width=0></TD><TD style="BORDER-LEFT: medium none" class=xl715995 width=0>MAX SEASONAL SNOWFALL</TD><TD style="BORDER-LEFT: medium none" class=xl715995 width=0></TD><TD style="BORDER-LEFT: medium none" class=xl725995 width=0>YEAR</TD><TD style="BORDER-LEFT: medium none; WIDTH: 122pt" class=xl715995 width=162>EARLIEST SNOWFALL</TD><TD style="BORDER-LEFT: medium none" class=xl715995 width=0></TD><TD style="BORDER-LEFT: medium none; WIDTH: 113pt" class=xl735995 width=150>LATEST SNOWFALL</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="HEIGHT: 15.75pt; BORDER-TOP: medium none" class=xl635995 height=21>1-Jan-88</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl645995>10-Jul-91</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl685995>106.0°F</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl655995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl685995>-31.0°F</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl655995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl695995>59KTS</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl655995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl655995>113</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl655995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl665995>107.3</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl655995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl655995>147</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl655995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl665995>43.0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl655995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl655995>10-11</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl645995>25-Nov-90</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl655995>1009</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl675995>30-Apr-90</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="HEIGHT: 15pt" class=xl745995 height=20></TD><TD class=xl745995></TD><TD class=xl755995></TD><TD class=xl765995></TD><TD class=xl755995></TD><TD class=xl765995></TD><TD class=xl765995></TD><TD class=xl765995></TD><TD class=xl765995></TD><TD class=xl765995></TD><TD class=xl775995></TD><TD class=xl765995></TD><TD class=xl765995></TD><TD class=xl765995></TD><TD class=xl785995></TD><TD class=xl765995></TD><TD class=xl765995></TD><TD class=xl745995></TD><TD class=xl765995></TD><TD class=xl745995></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="HEIGHT: 15pt" class=xl765995 height=20></TD><TD class=xl765995></TD><TD class=xl765995>Max Temp</TD><TD class=xl765995></TD><TD class=xl765995>Min Temp</TD><TD class=xl765995></TD><TD class=xl765995>Max Wind</TD><TD class=xl765995></TD><TD class=xl765995>TSTMS</TD><TD class=xl765995></TD><TD class=xl765995>SNOW</TD><TD class=xl765995></TD><TD class=xl765995>Days <0°F</TD><TD class=xl765995></TD><TD class=xl765995>Seasonal Max Snow</TD><TD class=xl765995></TD><TD class=xl795995></TD><TD class=xl765995>Earliest Snowfall</TD><TD class=xl765995></TD><TD class=xl765995>Latest Snowfall</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="HEIGHT: 15pt" class=xl765995 height=20></TD><TD class=xl805995></TD><TD style="BORDER-LEFT: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none" class=xl815995></TD><TD style="BORDER-LEFT: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none" class=xl805995></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="HEIGHT: 15pt" class=xl765995 height=20></TD><TD style="BORDER-TOP: medium none" class=xl825995>Jan-88</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>44</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl835995>44</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>-19</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>-19</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>37</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>37</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>9.6</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>9.6</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>17</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>17</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl845995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl855995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl865995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl865995></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="HEIGHT: 15pt" class=xl765995 height=20></TD><TD style="BORDER-TOP: medium none" class=xl825995>Feb-88</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>66</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl835995>66</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>-22</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>-22</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>46</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>46</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>1.9</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>1.9</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>11</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>11</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl845995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl855995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl865995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl865995></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="HEIGHT: 15pt" class=xl765995 height=20></TD><TD style="BORDER-TOP: medium none" class=xl825995>Mar-88</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>63</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl835995>63</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>4</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>4</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>47</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>47</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>9.2</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>9.2</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl845995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl855995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl865995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl865995></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="HEIGHT: 15pt" class=xl765995 height=20></TD><TD style="BORDER-TOP: medium none" class=xl825995>Apr-88</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>82</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl835995>82</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>17</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>17</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>42</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>42</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>1</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>1</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>T</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>T</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl845995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl855995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl865995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl865995>17-Apr-88</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="HEIGHT: 15pt" class=xl765995 height=20></TD><TD style="BORDER-TOP: medium none" class=xl825995>May-88</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>97</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl835995>97</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>31</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>31</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>46</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>46</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>7</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>7</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl845995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl855995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl865995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl865995></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="HEIGHT: 15pt" class=xl765995 height=20></TD><TD style="BORDER-TOP: medium none" class=xl825995>Jun-88</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>102</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl835995>102</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>49</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>49</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>42</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>42</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>3</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>3</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl845995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl855995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl865995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl865995></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="HEIGHT: 15pt" class=xl765995 height=20></TD><TD style="BORDER-TOP: medium none" class=xl825995>Jul-88</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>106</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl835995>106</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>49</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>49</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>47</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>47</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>7</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>7</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl845995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl855995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl865995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl865995></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="HEIGHT: 15pt" class=xl765995 height=20></TD><TD style="BORDER-TOP: medium none" class=xl825995>Aug-88</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>100</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl835995>100</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>34</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>34</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>59</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>59</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>5</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>5</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl845995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl855995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl865995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl865995></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="HEIGHT: 15pt" class=xl765995 height=20></TD><TD style="BORDER-TOP: medium none" class=xl825995>Sep-88</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>83</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl835995>83</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>36</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>36</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>42</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>42</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>2</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>2</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl845995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl855995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl865995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl865995></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="HEIGHT: 15pt" class=xl765995 height=20></TD><TD style="BORDER-TOP: medium none" class=xl825995>Oct-88</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>84</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl835995>84</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>9</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>9</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>45</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>45</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>T</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>T</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl845995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl855995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl865995>26-Oct-88</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>32442</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl865995></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="HEIGHT: 15pt" class=xl765995 height=20></TD><TD style="BORDER-TOP: medium none" class=xl825995>Nov-88</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>66</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl835995>66</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>39</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>39</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>6.1</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>6.1</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl845995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl855995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl865995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl865995></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="HEIGHT: 15pt" class=xl765995 height=20></TD><TD style="BORDER-TOP: medium none" class=xl825995>Dec-88</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>50</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl835995>50</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>-14</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>-14</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>37</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>37</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>9.6</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>9.6</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>11</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>11</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl845995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl855995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl865995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl865995></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="HEIGHT: 15pt" class=xl765995 height=20></TD><TD style="BORDER-TOP: medium none" class=xl825995>Jan-89</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>41</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl835995>41</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>-30</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>-30</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>39</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>39</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>20.7</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>20.7</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>10</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>10</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl845995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl855995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl865995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl865995></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="HEIGHT: 15pt" class=xl765995 height=20></TD><TD style="BORDER-TOP: medium none" class=xl825995>Feb-89</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>39</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl835995>39</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>-29</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>-29</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>39</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>39</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0.8</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0.8</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>16</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>16</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl845995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl855995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl865995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl865995></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="HEIGHT: 15pt" class=xl765995 height=20></TD><TD style="BORDER-TOP: medium none" class=xl825995>Mar-89</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>56</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl835995>56</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>-16</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>-16</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>37</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>37</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>5.1</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>5.1</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>5</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>5</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl845995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl855995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl865995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl865995></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="HEIGHT: 15pt" class=xl765995 height=20></TD><TD style="BORDER-TOP: medium none" class=xl825995>Apr-89</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>86</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl835995>86</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>11</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>11</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>45</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>45</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>2</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>2</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0.7</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0.7</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl845995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl855995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl865995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl865995></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="HEIGHT: 15pt" class=xl765995 height=20></TD><TD style="BORDER-TOP: medium none" class=xl825995>May-89</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>86</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl835995>86</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>24</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>24</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>45</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>45</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>5</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>5</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>T</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>T</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl875995>43.0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>43</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl885995>88-89</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl865995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl865995>5-May-89</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="HEIGHT: 15pt" class=xl765995 height=20></TD><TD style="BORDER-TOP: medium none" class=xl825995>Jun-89</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>91</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl835995>91</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>36</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>36</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>38</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>38</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>5</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>5</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl845995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl855995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl865995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl865995></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="HEIGHT: 15pt" class=xl765995 height=20></TD><TD style="BORDER-TOP: medium none" class=xl825995>Jul-89</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>105</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl835995>105</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>55</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>55</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>41</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>41</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>8</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>8</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl845995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl855995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl865995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl865995></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="HEIGHT: 15pt" class=xl765995 height=20></TD><TD style="BORDER-TOP: medium none" class=xl825995>Aug-89</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>105</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl835995>105</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>42</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>42</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>44</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>44</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>10</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>10</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl845995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl855995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl865995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl865995></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="HEIGHT: 15pt" class=xl765995 height=20></TD><TD style="BORDER-TOP: medium none" class=xl825995>Sep-89</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>98</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl835995>98</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>30</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>30</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>47</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>47</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>2</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>2</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl845995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl855995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl865995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl865995></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="HEIGHT: 15pt" class=xl765995 height=20></TD><TD style="BORDER-TOP: medium none" class=xl825995>Oct-89</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>75</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl835995>75</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>15</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>15</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>40</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>40</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0.6</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0.6</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl845995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl855995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl865995>31-Oct-89</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>32812</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl865995></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="HEIGHT: 15pt" class=xl765995 height=20></TD><TD style="BORDER-TOP: medium none" class=xl825995>Nov-89</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>62</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl835995>62</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>-5</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>-5</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>41</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>41</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>3.8</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>3.8</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>1</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>1</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl845995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl855995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl865995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl865995></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="HEIGHT: 15pt" class=xl765995 height=20></TD><TD style="BORDER-TOP: medium none" class=xl825995>Dec-89</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>45</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl835995>45</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>-29</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>-29</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>43</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>43</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>1.3</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>1.3</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>17</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>17</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl845995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl855995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl865995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl865995></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="HEIGHT: 15pt" class=xl765995 height=20></TD><TD style="BORDER-TOP: medium none" class=xl825995>Jan-90</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>49</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl835995>49</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>-11</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>-11</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>59</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>59</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>1.8</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>1.8</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>3</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>3</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl845995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl855995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl865995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl865995></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="HEIGHT: 15pt" class=xl765995 height=20></TD><TD style="BORDER-TOP: medium none" class=xl825995>Feb-90</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>52</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl835995>52</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>-20</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>-20</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>41</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>41</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0.8</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0.8</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>8</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>8</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl845995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl855995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl865995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl865995></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="HEIGHT: 15pt" class=xl765995 height=20></TD><TD style="BORDER-TOP: medium none" class=xl825995>Mar-90</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>67</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl835995>67</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>6</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>6</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>44</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>44</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>1</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>1</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>9.1</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>9.1</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl845995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl855995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl865995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl865995></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="HEIGHT: 15pt" class=xl765995 height=20></TD><TD style="BORDER-TOP: medium none" class=xl825995>Apr-90</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>86</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl835995>86</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>16</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>16</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>38</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>38</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>3</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>3</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>2.6</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>2.6</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl845995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl855995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl865995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl865995>30-Apr-90</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="HEIGHT: 15pt" class=xl765995 height=20></TD><TD style="BORDER-TOP: medium none" class=xl825995>May-90</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>82</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl835995>82</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>21</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>21</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>43</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>43</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>1</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>1</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl875995>20.0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>20</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl885995>89-90</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl865995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl865995></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="HEIGHT: 15pt" class=xl765995 height=20></TD><TD style="BORDER-TOP: medium none" class=xl825995>Jun-90</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>93</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl835995>93</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>40</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>40</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>36</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>36</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>11</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>11</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl845995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl855995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl865995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl865995></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="HEIGHT: 15pt" class=xl765995 height=20></TD><TD style="BORDER-TOP: medium none" class=xl825995>Jul-90</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>92</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl835995>92</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>48</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>48</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>36</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>36</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>8</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>8</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl845995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl855995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl865995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl865995></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="HEIGHT: 15pt" class=xl765995 height=20></TD><TD style="BORDER-TOP: medium none" class=xl825995>Aug-90</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>99</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl835995>99</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>50</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>50</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>48</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>48</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>9</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>9</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl845995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl855995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl865995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl865995></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="HEIGHT: 15pt" class=xl765995 height=20></TD><TD style="BORDER-TOP: medium none" class=xl825995>Sep-90</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>99</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl835995>99</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>32</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>32</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>34</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>34</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>2</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>2</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl845995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl855995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl865995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl865995></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="HEIGHT: 15pt" class=xl765995 height=20></TD><TD style="BORDER-TOP: medium none" class=xl825995>Oct-90</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>82</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl835995>82</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>14</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>14</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>50</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>50</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl845995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl855995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl865995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl865995></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="HEIGHT: 15pt" class=xl765995 height=20></TD><TD style="BORDER-TOP: medium none" class=xl825995>Nov-90</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>64</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl835995>64</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>-6</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>-6</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>45</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>45</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>T</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>T</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>1</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>1</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl845995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl855995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl865995>25-Nov-90</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>33202</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl865995></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="HEIGHT: 15pt" class=xl765995 height=20></TD><TD style="BORDER-TOP: medium none" class=xl825995>Dec-90</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>82</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl835995>82</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>-31</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>-31</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>41</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>41</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>4.7</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>4.7</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>19</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>19</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl845995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl855995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl865995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl865995></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="HEIGHT: 15pt" class=xl765995 height=20></TD><TD style="BORDER-TOP: medium none" class=xl825995>Jan-91</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>45</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl835995>45</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>-24</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>-24</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>44</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>44</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>1.2</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>1.2</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>20</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>20</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl845995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl855995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl865995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl865995></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="HEIGHT: 15pt" class=xl765995 height=20></TD><TD style="BORDER-TOP: medium none" class=xl825995>Feb-91</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>57</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl835995>57</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>-11</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>-11</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>30</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>30</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>6.7</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>6.7</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>4</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>4</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl845995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl855995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl865995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl865995></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="HEIGHT: 15pt" class=xl765995 height=20></TD><TD style="BORDER-TOP: medium none" class=xl825995>Mar-91</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>69</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl835995>69</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>-8</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>-8</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>38</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>38</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>2.7</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>2.7</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>4</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>4</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl845995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl855995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl865995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl865995></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="HEIGHT: 15pt" class=xl765995 height=20></TD><TD style="BORDER-TOP: medium none" class=xl825995>Apr-91</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>83</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl835995>83</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>21</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>21</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>41</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>41</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>1</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>1</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>4.4</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>4.4</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl845995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl855995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl865995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl865995></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="HEIGHT: 15pt" class=xl765995 height=20></TD><TD style="BORDER-TOP: medium none" class=xl825995>May-91</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>89</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl835995>89</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>24</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>24</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>31</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>31</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>5</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>5</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>3.9</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>3.9</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl875995>23.6</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>23.6</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl885995>90-91</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl865995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl865995>12-May-91</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="HEIGHT: 15pt" class=xl765995 height=20></TD><TD style="BORDER-TOP: medium none" class=xl825995>Jun-91</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>88</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl835995>88</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>47</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>47</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>45</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>45</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>8</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>8</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl845995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl855995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl865995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl865995></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="HEIGHT: 15pt" class=xl765995 height=20></TD><TD style="BORDER-TOP: medium none" class=xl825995>Jul-91</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>98</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl835995>98</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>46</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>46</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>44</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>44</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>7</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>7</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995>0</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl845995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl855995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl865995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl805995></TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl865995></TD></TR></TBODY></TABLE>

Aladin Akyurek · Sep 8, 2011

Would you check the following:

C2, control+shift+enter, not just enter:

=INDEX($C$6:$C$48,MATCH(MIN(IF($C$6:$C$48>=A2,IF($C$6:$C$48<=B2,$C$6:$C$48-YEAR($C$6:$C$48)))),IF($C$6:$C$48>=A2,IF($C$6:$C$48<=B2,$C$6:$C$48-YEAR($C$6:$C$48))),0))

D2, control+shift+enter, not just enter:

=INDEX($E$6:$E$48,MATCH(MAX(IF($E$6:$E$48>=A2,IF($E$6:$E$48<=B2,$E$6:$E$48-YEAR($E$6:$E$48)))),IF($E$6:$E$48>=A2,IF($E$6:$E$48<=B2,$E$6:$E$48-YEAR($E$6:$E$48))),0))

These formulas calculates on dates values from which the year component is removed...

joferder · Sep 8, 2011

Aladin,

Thanks again for your help with this. I tried the formulas that you gave me, but they still aren't working.

When I expand the window that I want it to search within, the dates that returned are incorrect. In the example of cells that I gave, it worked out that the first date listed for Earliest Snowfall was also the earliest when it comes to year, but when I changed the end date to 10-Jul-1995 the correct date that it should come up with is 17-Sep-91, but instead it still shows 26-Oct-88. It does the same thing for for the Latest Snowfall date, except it always shows the latest date by year (the dates that I gave in the example spreadsheet above should return 5-May-89 but instead I get 30-Apr-90).

Again, thanks for your help with this, especially at this late hour. I would really like to get this finished so that people here can start using it.

John

Earliest/Latest Calendar Day

joferder

Board Regular

joferder

Board Regular

Excel Facts

Aladin Akyurek

MrExcel MVP

joferder

Board Regular

Similar threads

Forum statistics

Share this page

Earliest/Latest Calendar Day

joferder

Board Regular

joferder

Board Regular

Excel Facts

Aladin Akyurek

MrExcel MVP

joferder

Board Regular

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock