Dynamic Conditional MIN

J

JEscobed

New Member
Joined
Mar 22, 2011
Messages
9
Hello,
I was hoping someone could please help me with this. I want to find the minimum of a set of values, as long as the values are within 30 days of each other. Also, the 30 day window may not always occur within the same month (i.e. spanning 6/25-7/5). Could someone please help me?

<TABLE style="WIDTH: 104pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=139 border=0><COLGROUP><COL style="WIDTH: 56pt; mso-width-source: userset; mso-width-alt: 2742" width=75><COL style="WIDTH: 48pt" width=64><TBODY><TR style="HEIGHT: 15pt" height=20><TD class=xl63 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 56pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" align=right width=75 height=20>2011/06/09</TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" align=right width=64>574</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl63 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" align=right height=20>2011/06/09</TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" align=right>574</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl63 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" align=right height=20>2011/06/07</TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" align=right>571.05</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl63 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" align=right height=20>2011/06/06</TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" align=right>572.8</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl63 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" align=right height=20>2011/06/03</TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" align=right>578.5</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl63 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" align=right height=20>2011/06/02</TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" align=right>583.23</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl63 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" align=right height=20>2011/03/18</TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" align=right>572.93</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl63 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" align=right height=20>2011/03/17</TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" align=right>570.72</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl63 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" align=right height=20>2011/03/16</TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" align=right>562.51</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl63 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" align=right height=20>2011/03/15</TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" align=right>575.2</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl63 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" align=right height=20>2010/11/30</TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" align=right>529.73</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl63 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" align=right height=20>2010/09/01</TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" align=right>489.04</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl63 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" align=right height=20>2010/08/31</TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" align=right>475.73</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl63 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" align=right height=20>2010/08/30</TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" align=right>475.35</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl63 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" align=right height=20>2010/08/27</TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" align=right>481.95</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl63 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" align=right height=20>2010/08/26</TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" align=right>474.77</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl63 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" align=right height=20>2010/08/25</TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" align=right>478.67</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl63 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" align=right height=20>2010/08/24</TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" align=right>477.44</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl63 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" align=right height=20>2010/08/23</TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" align=right>484.36</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl63 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" align=right height=20>2010/08/20</TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" align=right>485.86</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl63 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" align=right height=20>2010/08/19</TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" align=right>488.24</TD></TR></TBODY></TABLE>


Jill
 

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
Sort by date Sort by votes
How will the column with dates exist? Will it be sorted by date? Will there be data for every day? Is this a one time deal or will you be doing this often?

This can be done using =SMALL([data range]) but I'm not sure the scope of what you are doing.

What record will you use to set the 30 day window with (the bottom/top value in the column)?
 
Last edited:
Upvote 0
Hi Desu,
The dates are sorted by day, there will not be data for each day, and I'll be doing this often.

I've tried using small, but I"m having problems automatically finding the range since I only want to choose the data that occurs within 30 days of each other.

Basically, for the data I would want the following values returned

<TABLE style="WIDTH: 104pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=139 border=0><COLGROUP><COL style="WIDTH: 56pt; mso-width-source: userset; mso-width-alt: 2742" width=75><COL style="WIDTH: 48pt" width=64><TBODY><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 56pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" align=right width=75 height=20>2011/06/07</TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" align=right width=64>571.05</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" align=right height=20>2011/03/16</TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" align=right>562.51</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" align=right height=20>2010/11/30</TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" align=right>529.73</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" align=right height=20>2010/08/26</TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" align=right>474.77</TD></TR></TBODY></TABLE>
 
Upvote 0
Sorting your dates ascending,

<TABLE style="WIDTH: 219pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=291 x:str><COLGROUP><COL style="WIDTH: 65pt; mso-width-source: userset; mso-width-alt: 3949" width=86><COL style="WIDTH: 37pt" width=49><COL style="WIDTH: 61pt; mso-width-source: userset; mso-width-alt: 3730" width=82><COL style="WIDTH: 56pt; mso-width-source: userset; mso-width-alt: 3401" width=74><TBODY><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #f3f3f3; WIDTH: 65pt; HEIGHT: 12pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl29 height=16 width=86>Date</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f3f3f3; WIDTH: 37pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl29 width=49>Value</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f3f3f3; WIDTH: 61pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl29 width=82>Date+30</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #f3f3f3; WIDTH: 56pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl29 width=74>Least?</TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 65pt; HEIGHT: 12pt; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8" class=xl30 height=16 width=86 x:num="40409">19 Aug 2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 37pt; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8" class=xl31 width=49 x:num>488.24</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 61pt; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8" class=xl30 width=82 x:num="40422" x:fmla="=LOOKUP(A2+30, $A$2:$A$22)">1 Sep 2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8" class=xl32 x:str="" x:fmla='=IF(B2=MIN(IF($C$2:$C$22=C2, $B$2:$B$22)), "x", "")' x:arrayrange="D2"> </TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 65pt; HEIGHT: 12pt; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8" class=xl30 height=16 width=86 x:num="40410">20 Aug 2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 37pt; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8" class=xl31 width=49 x:num>485.86</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 61pt; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8" class=xl30 width=82 x:num="40422" x:fmla="=LOOKUP(A3+30, $A$2:$A$22)">1 Sep 2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8" class=xl32 x:str="" x:fmla='=IF(B3=MIN(IF($C$2:$C$22=C3, $B$2:$B$22)), "x", "")' x:arrayrange="D3"> </TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 65pt; HEIGHT: 12pt; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8" class=xl30 height=16 width=86 x:num="40413">23 Aug 2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 37pt; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8" class=xl31 width=49 x:num>484.36</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 61pt; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8" class=xl30 width=82 x:num="40422" x:fmla="=LOOKUP(A4+30, $A$2:$A$22)">1 Sep 2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8" class=xl32 x:str="" x:fmla='=IF(B4=MIN(IF($C$2:$C$22=C4, $B$2:$B$22)), "x", "")' x:arrayrange="D4"> </TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 65pt; HEIGHT: 12pt; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8" class=xl30 height=16 width=86 x:num="40414">24 Aug 2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 37pt; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8" class=xl31 width=49 x:num>477.44</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 61pt; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8" class=xl30 width=82 x:num="40422" x:fmla="=LOOKUP(A5+30, $A$2:$A$22)">1 Sep 2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8" class=xl32 x:str="" x:fmla='=IF(B5=MIN(IF($C$2:$C$22=C5, $B$2:$B$22)), "x", "")' x:arrayrange="D5"> </TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 65pt; HEIGHT: 12pt; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8" class=xl30 height=16 width=86 x:num="40415">25 Aug 2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 37pt; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8" class=xl31 width=49 x:num>478.67</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 61pt; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8" class=xl30 width=82 x:num="40422" x:fmla="=LOOKUP(A6+30, $A$2:$A$22)">1 Sep 2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8" class=xl32 x:str="" x:fmla='=IF(B6=MIN(IF($C$2:$C$22=C6, $B$2:$B$22)), "x", "")' x:arrayrange="D6"> </TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 65pt; HEIGHT: 12pt; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8" class=xl30 height=16 width=86 x:num="40416">26 Aug 2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 37pt; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8" class=xl31 width=49 x:num>474.77</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 61pt; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8" class=xl30 width=82 x:num="40422" x:fmla="=LOOKUP(A7+30, $A$2:$A$22)">1 Sep 2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8" class=xl32 x:fmla='=IF(B7=MIN(IF($C$2:$C$22=C7, $B$2:$B$22)), "x", "")' x:arrayrange="D7">x</TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 65pt; HEIGHT: 12pt; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8" class=xl30 height=16 width=86 x:num="40417">27 Aug 2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 37pt; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8" class=xl31 width=49 x:num>481.95</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 61pt; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8" class=xl30 width=82 x:num="40422" x:fmla="=LOOKUP(A8+30, $A$2:$A$22)">1 Sep 2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8" class=xl32 x:str="" x:fmla='=IF(B8=MIN(IF($C$2:$C$22=C8, $B$2:$B$22)), "x", "")' x:arrayrange="D8"> </TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 65pt; HEIGHT: 12pt; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8" class=xl30 height=16 width=86 x:num="40420">30 Aug 2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 37pt; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8" class=xl31 width=49 x:num>475.35</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 61pt; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8" class=xl30 width=82 x:num="40422" x:fmla="=LOOKUP(A9+30, $A$2:$A$22)">1 Sep 2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8" class=xl32 x:str="" x:fmla='=IF(B9=MIN(IF($C$2:$C$22=C9, $B$2:$B$22)), "x", "")' x:arrayrange="D9"> </TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 65pt; HEIGHT: 12pt; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8" class=xl30 height=16 width=86 x:num="40421">31 Aug 2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 37pt; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8" class=xl31 width=49 x:num>475.73</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 61pt; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8" class=xl30 width=82 x:num="40422" x:fmla="=LOOKUP(A10+30, $A$2:$A$22)">1 Sep 2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8" class=xl32 x:str="" x:fmla='=IF(B10=MIN(IF($C$2:$C$22=C10, $B$2:$B$22)), "x", "")' x:arrayrange="D10"> </TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 65pt; HEIGHT: 12pt; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8" class=xl30 height=16 width=86 x:num="40422">1 Sep 2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 37pt; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8" class=xl31 width=49 x:num>489.04</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 61pt; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8" class=xl30 width=82 x:num="40422" x:fmla="=LOOKUP(A11+30, $A$2:$A$22)">1 Sep 2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8" class=xl32 x:str="" x:fmla='=IF(B11=MIN(IF($C$2:$C$22=C11, $B$2:$B$22)), "x", "")' x:arrayrange="D11"> </TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 65pt; HEIGHT: 12pt; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8" class=xl30 height=16 width=86 x:num="40512">30 Nov 2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 37pt; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8" class=xl31 width=49 x:num>529.73</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 61pt; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8" class=xl30 width=82 x:num="40512" x:fmla="=LOOKUP(A12+30, $A$2:$A$22)">30 Nov 2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8" class=xl32 x:fmla='=IF(B12=MIN(IF($C$2:$C$22=C12, $B$2:$B$22)), "x", "")' x:arrayrange="D12">x</TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 65pt; HEIGHT: 12pt; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8" class=xl30 height=16 width=86 x:num="40617">15 Mar 2011</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 37pt; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8" class=xl31 width=49 x:num>575.20</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 61pt; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8" class=xl30 width=82 x:num="40620" x:fmla="=LOOKUP(A13+30, $A$2:$A$22)">18 Mar 2011</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8" class=xl32 x:str="" x:fmla='=IF(B13=MIN(IF($C$2:$C$22=C13, $B$2:$B$22)), "x", "")' x:arrayrange="D13"> </TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 65pt; HEIGHT: 12pt; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8" class=xl30 height=16 width=86 x:num="40618">16 Mar 2011</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 37pt; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8" class=xl31 width=49 x:num>562.51</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 61pt; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8" class=xl30 width=82 x:num="40620" x:fmla="=LOOKUP(A14+30, $A$2:$A$22)">18 Mar 2011</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8" class=xl32 x:fmla='=IF(B14=MIN(IF($C$2:$C$22=C14, $B$2:$B$22)), "x", "")' x:arrayrange="D14">x</TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 65pt; HEIGHT: 12pt; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8" class=xl30 height=16 width=86 x:num="40619">17 Mar 2011</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 37pt; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8" class=xl31 width=49 x:num>570.72</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 61pt; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8" class=xl30 width=82 x:num="40620" x:fmla="=LOOKUP(A15+30, $A$2:$A$22)">18 Mar 2011</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8" class=xl32 x:str="" x:fmla='=IF(B15=MIN(IF($C$2:$C$22=C15, $B$2:$B$22)), "x", "")' x:arrayrange="D15"> </TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 65pt; HEIGHT: 12pt; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8" class=xl30 height=16 width=86 x:num="40620">18 Mar 2011</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 37pt; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8" class=xl31 width=49 x:num>572.93</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 61pt; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8" class=xl30 width=82 x:num="40620" x:fmla="=LOOKUP(A16+30, $A$2:$A$22)">18 Mar 2011</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8" class=xl32 x:str="" x:fmla='=IF(B16=MIN(IF($C$2:$C$22=C16, $B$2:$B$22)), "x", "")' x:arrayrange="D16"> </TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 65pt; HEIGHT: 12pt; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8" class=xl30 height=16 width=86 x:num="40696">2 Jun 2011</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 37pt; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8" class=xl31 width=49 x:num>583.23</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 61pt; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8" class=xl30 width=82 x:num="40703" x:fmla="=LOOKUP(A17+30, $A$2:$A$22)">9 Jun 2011</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8" class=xl32 x:str="" x:fmla='=IF(B17=MIN(IF($C$2:$C$22=C17, $B$2:$B$22)), "x", "")' x:arrayrange="D17"> </TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 65pt; HEIGHT: 12pt; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8" class=xl30 height=16 width=86 x:num="40697">3 Jun 2011</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 37pt; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8" class=xl31 width=49 x:num>578.50</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 61pt; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8" class=xl30 width=82 x:num="40703" x:fmla="=LOOKUP(A18+30, $A$2:$A$22)">9 Jun 2011</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8" class=xl32 x:str="" x:fmla='=IF(B18=MIN(IF($C$2:$C$22=C18, $B$2:$B$22)), "x", "")' x:arrayrange="D18"> </TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 65pt; HEIGHT: 12pt; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8" class=xl30 height=16 width=86 x:num="40700">6 Jun 2011</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 37pt; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8" class=xl31 width=49 x:num>572.80</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 61pt; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8" class=xl30 width=82 x:num="40703" x:fmla="=LOOKUP(A19+30, $A$2:$A$22)">9 Jun 2011</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8" class=xl32 x:str="" x:fmla='=IF(B19=MIN(IF($C$2:$C$22=C19, $B$2:$B$22)), "x", "")' x:arrayrange="D19"> </TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 65pt; HEIGHT: 12pt; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8" class=xl30 height=16 width=86 x:num="40701">7 Jun 2011</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 37pt; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8" class=xl31 width=49 x:num>571.05</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 61pt; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8" class=xl30 width=82 x:num="40703" x:fmla="=LOOKUP(A20+30, $A$2:$A$22)">9 Jun 2011</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8" class=xl32 x:fmla='=IF(B20=MIN(IF($C$2:$C$22=C20, $B$2:$B$22)), "x", "")' x:arrayrange="D20">x</TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 65pt; HEIGHT: 12pt; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8" class=xl30 height=16 width=86 x:num="40703">9 Jun 2011</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 37pt; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8" class=xl31 width=49 x:num>574.00</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 61pt; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8" class=xl30 width=82 x:num="40703" x:fmla="=LOOKUP(A21+30, $A$2:$A$22)">9 Jun 2011</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8" class=xl32 x:str="" x:fmla='=IF(B21=MIN(IF($C$2:$C$22=C21, $B$2:$B$22)), "x", "")' x:arrayrange="D21"> </TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 65pt; HEIGHT: 12pt; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8" class=xl30 height=16 width=86 x:num="40703">9 Jun 2011</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 37pt; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8" class=xl31 width=49 x:num>574.00</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; WIDTH: 61pt; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8" class=xl30 width=82 x:num="40703" x:fmla="=LOOKUP(A22+30, $A$2:$A$22)">9 Jun 2011</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: white; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8" class=xl32 x:str="" x:fmla='=IF(B22=MIN(IF($C$2:$C$22=C22, $B$2:$B$22)), "x", "")' x:arrayrange="D22"> </TD></TR></TBODY></TABLE>

The formula in C2 and copied down is

=LOOKUP(A2+30, $A$2:$A$22)

The formula in D2 and copied down is

=IF(B2=MIN(IF($C$2:$C$22=C2, $B$2:$B$22)), "x", "")

... which MUST be confirmed with Ctrl+Shift+Enter.
 
Last edited:
Upvote 0
You must log in or register to reply here.

Similar threads

D
  • Solved
VBA Function to Paste Table into Outlook Email Resulting in HTML language in Email
Replies
8
Views
623
smozgur
smozgur
B
  • Question Question
Excel Pivot Table to see the number of "Lost Calls"
Replies
0
Views
68
Bernie Galve
B
E
  • Question Question
VBA code clean up
Replies
9
Views
583
mumps
mumps
D
  • Question Question
Looking for a way to allocate shifts between teams, maybe a LET formula
Replies
0
Views
90
Dazzybeeguy
D
A
  • Question Question
Find entries in a sheet available or not
2
Replies
10
Views
493
AFZAL SOHAIL
A

Forum statistics

Threads
1,224,598
Messages
6,179,818
Members
452,946
Latest member
JoseDavid

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