Complicated formula help

[currybai]

Hi,

I want to be able to count the views and clicks by the date and ID but I only want the lesser of the views. For example on 6/23, for ID 114, there are 2 ID2, 15 & 8, and for 15 there is 29011 views and for 8 there is 27743 views, but I want only to count the 27743 views for that ID. I need to do this for all the dates. Is there a way?


<b>Excel 2007</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6"><colgroup><col width="25px" style="background-color: #E0E0F0" /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th></th><th>A</th><th>B</th><th>C</th><th>D</th><th>E</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style=";">Date</td><td style=";">ID</td><td style=";">ID2</td><td style=";">Views</td><td style=";">clicks</td></tr><tr ><td style="color: #161120;text-align: center;">2</td><td style="text-align: right;;">6/23/2011 0:00</td><td style="text-align: right;;">114</td><td style="text-align: right;;">15</td><td style="text-align: right;;">29011</td><td style="text-align: right;;">21</td></tr><tr ><td style="color: #161120;text-align: center;">3</td><td style="text-align: right;;">6/23/2011 0:00</td><td style="text-align: right;;">114</td><td style="text-align: right;;">8</td><td style="text-align: right;;">27743</td><td style="text-align: right;;">26</td></tr><tr ><td style="color: #161120;text-align: center;">4</td><td style="text-align: right;;">6/23/2011 0:00</td><td style="text-align: right;;">140</td><td style="text-align: right;;">15</td><td style="text-align: right;;">2</td><td style="text-align: right;;">1</td></tr><tr ><td style="color: #161120;text-align: center;">5</td><td style="text-align: right;;">6/23/2011 0:00</td><td style="text-align: right;;">140</td><td style="text-align: right;;">10</td><td style="text-align: right;;">2</td><td style="text-align: right;;">1</td></tr><tr ><td style="color: #161120;text-align: center;">6</td><td style="text-align: right;;">6/23/2011 0:00</td><td style="text-align: right;;">191</td><td style="text-align: right;;">10</td><td style="text-align: right;;">7551</td><td style="text-align: right;;">4</td></tr><tr ><td style="color: #161120;text-align: center;">7</td><td style="text-align: right;;">6/23/2011 0:00</td><td style="text-align: right;;">191</td><td style="text-align: right;;">15</td><td style="text-align: right;;">10924</td><td style="text-align: right;;">9</td></tr><tr ><td style="color: #161120;text-align: center;">8</td><td style="text-align: right;;">6/23/2011 0:00</td><td style="text-align: right;;">370</td><td style="text-align: right;;">15</td><td style="text-align: right;;">54635</td><td style="text-align: right;;">12</td></tr><tr ><td style="color: #161120;text-align: center;">9</td><td style="text-align: right;;">6/23/2011 0:00</td><td style="text-align: right;;">370</td><td style="text-align: right;;">10</td><td style="text-align: right;;">35481</td><td style="text-align: right;;">11</td></tr><tr ><td style="color: #161120;text-align: center;">10</td><td style="text-align: right;;">6/23/2011 0:00</td><td style="text-align: right;;">370</td><td style="text-align: right;;">8</td><td style="text-align: right;;">18578</td><td style="text-align: right;;">9</td></tr><tr ><td style="color: #161120;text-align: center;">11</td><td style="text-align: right;;">6/24/2011 0:00</td><td style="text-align: right;;">114</td><td style="text-align: right;;">15</td><td style="text-align: right;;">49145</td><td style="text-align: right;;">28</td></tr><tr ><td style="color: #161120;text-align: center;">12</td><td style="text-align: right;;">6/24/2011 0:00</td><td style="text-align: right;;">114</td><td style="text-align: right;;">8</td><td style="text-align: right;;">45627</td><td style="text-align: right;;">29</td></tr><tr ><td style="color: #161120;text-align: center;">13</td><td style="text-align: right;;">6/24/2011 0:00</td><td style="text-align: right;;">114</td><td style="text-align: right;;">10</td><td style="text-align: right;;">43</td><td style="text-align: right;;">0</td></tr><tr ><td style="color: #161120;text-align: center;">14</td><td style="text-align: right;;">6/24/2011 0:00</td><td style="text-align: right;;">140</td><td style="text-align: right;;">15</td><td style="text-align: right;;">77437</td><td style="text-align: right;;">34</td></tr><tr ><td style="color: #161120;text-align: center;">15</td><td style="text-align: right;;">6/24/2011 0:00</td><td style="text-align: right;;">140</td><td style="text-align: right;;">10</td><td style="text-align: right;;">58022</td><td style="text-align: right;;">53</td></tr><tr ><td style="color: #161120;text-align: center;">16</td><td style="text-align: right;;">6/24/2011 0:00</td><td style="text-align: right;;">191</td><td style="text-align: right;;">10</td><td style="text-align: right;;">24070</td><td style="text-align: right;;">12</td></tr><tr ><td style="color: #161120;text-align: center;">17</td><td style="text-align: right;;">6/24/2011 0:00</td><td style="text-align: right;;">191</td><td style="text-align: right;;">15</td><td style="text-align: right;;">36010</td><td style="text-align: right;;">19</td></tr></tbody></table><p style="width:3.6em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #A6AAB6;border-top:none;text-align: center;background-color: #E0E0F0;color: #161120">Sheet3</p><br /><br />

 

[javalover]

Why not use the subtotal function (for each change in ID, count, columns C, D & E)?

 

[Marcelo Branco]

Or maybe a Pivot Table

<TABLE style="WIDTH: 130pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=174><COLGROUP><COL style="WIDTH: 71pt; mso-width-source: userset; mso-width-alt: 3474" width=95><COL style="WIDTH: 59pt; mso-width-source: userset; mso-width-alt: 2889" width=79><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 71pt; FONT-FAMILY: Calibri; BACKGROUND: #4f81bd; HEIGHT: 15pt; COLOR: white; FONT-SIZE: 11pt; BORDER-TOP: windowtext 0.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: windowtext 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #4F81BD none" class=xl63 height=20 width=95>Dates</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 59pt; FONT-FAMILY: Calibri; BACKGROUND: #4f81bd; COLOR: white; FONT-SIZE: 11pt; BORDER-TOP: windowtext 0.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: windowtext 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #4F81BD none" class=xl64 width=79>Views (min)</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; FONT-FAMILY: Calibri; BACKGROUND: #dce6f1; HEIGHT: 15pt; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: windowtext 0.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: windowtext 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #DCE6F1 none" class=xl65 height=20>23/6/11 0:00</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; FONT-FAMILY: Calibri; BACKGROUND: #dce6f1; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: windowtext 0.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: windowtext 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #DCE6F1 none" class=xl66> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; HEIGHT: 15pt; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: windowtext 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: windowtext 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" class=xl67 height=20>114</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: windowtext 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: windowtext 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" class=xl66 align=right>27.743</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; HEIGHT: 15pt; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: windowtext 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: windowtext 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" class=xl67 height=20>140</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: windowtext 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: windowtext 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" class=xl66 align=right>2</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; HEIGHT: 15pt; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: windowtext 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: windowtext 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" class=xl67 height=20>191</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: windowtext 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: windowtext 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" class=xl66 align=right>7.551</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; HEIGHT: 15pt; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: windowtext 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: windowtext 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" class=xl67 height=20>370</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: windowtext 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: windowtext 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" class=xl66 align=right>18.578</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; HEIGHT: 15pt; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: windowtext 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: windowtext 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" class=xl65 height=20> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: windowtext 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: windowtext 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" class=xl66> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; FONT-FAMILY: Calibri; BACKGROUND: #dce6f1; HEIGHT: 15pt; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: windowtext 0.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: windowtext 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #DCE6F1 none" class=xl65 height=20>24/6/11 0:00</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; FONT-FAMILY: Calibri; BACKGROUND: #dce6f1; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: windowtext 0.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: windowtext 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #DCE6F1 none" class=xl66> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; HEIGHT: 15pt; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: windowtext 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: windowtext 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" class=xl67 height=20>114</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: windowtext 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: windowtext 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" class=xl66 align=right>43</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; HEIGHT: 15pt; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: windowtext 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: windowtext 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" class=xl67 height=20>140</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: windowtext 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: windowtext 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" class=xl66 align=right>58.022</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; HEIGHT: 15pt; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: windowtext 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: windowtext 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" class=xl67 height=20>191</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: windowtext 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: windowtext 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" class=xl66 align=right>24.070</TD></TR></TBODY></TABLE>

HTH

M.

 

[T. Valko]

Hi,

I want to be able to count the views and clicks by the date and ID but I only want the lesser of the views. For example on 6/23, for ID 114, there are 2 ID2, 15 & 8, and for 15 there is 29011 views and for 8 there is 27743 views, but I want only to count the 27743 views for that ID. I need to do this for all the dates. Is there a way?


Excel 2007<TABLE style="BORDER-RIGHT: #a6aab6 1px solid; BORDER-TOP: #a6aab6 1px solid; BORDER-LEFT: #a6aab6 1px solid; BORDER-BOTTOM: #a6aab6 1px solid; BORDER-COLLAPSE: collapse; BACKGROUND-COLOR: #ffffff" cellPadding=2 rules=all><COLGROUP><COL style="BACKGROUND-COLOR: #e0e0f0" width=25><COL><COL><COL><COL><COL></COLGROUP><THEAD><TR style="COLOR: #161120; BACKGROUND-COLOR: #e0e0f0; TEXT-ALIGN: center"><TH></TH><TH>A</TH><TH>B</TH><TH>C</TH><TH>D</TH><TH>E</TH></TR></THEAD><TBODY><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">1</TD><TD>Date</TD><TD>ID</TD><TD>ID2</TD><TD>Views</TD><TD>clicks</TD></TR><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">2</TD><TD style="TEXT-ALIGN: right">6/23/2011 0:00</TD><TD style="TEXT-ALIGN: right">114</TD><TD style="TEXT-ALIGN: right">15</TD><TD style="TEXT-ALIGN: right">29011</TD><TD style="TEXT-ALIGN: right">21</TD></TR><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">3</TD><TD style="TEXT-ALIGN: right">6/23/2011 0:00</TD><TD style="TEXT-ALIGN: right">114</TD><TD style="TEXT-ALIGN: right">8</TD><TD style="TEXT-ALIGN: right">27743</TD><TD style="TEXT-ALIGN: right">26</TD></TR><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">4</TD><TD style="TEXT-ALIGN: right">6/23/2011 0:00</TD><TD style="TEXT-ALIGN: right">140</TD><TD style="TEXT-ALIGN: right">15</TD><TD style="TEXT-ALIGN: right">2</TD><TD style="TEXT-ALIGN: right">1</TD></TR><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">5</TD><TD style="TEXT-ALIGN: right">6/23/2011 0:00</TD><TD style="TEXT-ALIGN: right">140</TD><TD style="TEXT-ALIGN: right">10</TD><TD style="TEXT-ALIGN: right">2</TD><TD style="TEXT-ALIGN: right">1</TD></TR><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">6</TD><TD style="TEXT-ALIGN: right">6/23/2011 0:00</TD><TD style="TEXT-ALIGN: right">191</TD><TD style="TEXT-ALIGN: right">10</TD><TD style="TEXT-ALIGN: right">7551</TD><TD style="TEXT-ALIGN: right">4</TD></TR><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">7</TD><TD style="TEXT-ALIGN: right">6/23/2011 0:00</TD><TD style="TEXT-ALIGN: right">191</TD><TD style="TEXT-ALIGN: right">15</TD><TD style="TEXT-ALIGN: right">10924</TD><TD style="TEXT-ALIGN: right">9</TD></TR><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">8</TD><TD style="TEXT-ALIGN: right">6/23/2011 0:00</TD><TD style="TEXT-ALIGN: right">370</TD><TD style="TEXT-ALIGN: right">15</TD><TD style="TEXT-ALIGN: right">54635</TD><TD style="TEXT-ALIGN: right">12</TD></TR><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">9</TD><TD style="TEXT-ALIGN: right">6/23/2011 0:00</TD><TD style="TEXT-ALIGN: right">370</TD><TD style="TEXT-ALIGN: right">10</TD><TD style="TEXT-ALIGN: right">35481</TD><TD style="TEXT-ALIGN: right">11</TD></TR><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">10</TD><TD style="TEXT-ALIGN: right">6/23/2011 0:00</TD><TD style="TEXT-ALIGN: right">370</TD><TD style="TEXT-ALIGN: right">8</TD><TD style="TEXT-ALIGN: right">18578</TD><TD style="TEXT-ALIGN: right">9</TD></TR><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">11</TD><TD style="TEXT-ALIGN: right">6/24/2011 0:00</TD><TD style="TEXT-ALIGN: right">114</TD><TD style="TEXT-ALIGN: right">15</TD><TD style="TEXT-ALIGN: right">49145</TD><TD style="TEXT-ALIGN: right">28</TD></TR><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">12</TD><TD style="TEXT-ALIGN: right">6/24/2011 0:00</TD><TD style="TEXT-ALIGN: right">114</TD><TD style="TEXT-ALIGN: right">8</TD><TD style="TEXT-ALIGN: right">45627</TD><TD style="TEXT-ALIGN: right">29</TD></TR><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">13</TD><TD style="TEXT-ALIGN: right">6/24/2011 0:00</TD><TD style="TEXT-ALIGN: right">114</TD><TD style="TEXT-ALIGN: right">10</TD><TD style="TEXT-ALIGN: right">43</TD><TD style="TEXT-ALIGN: right">0</TD></TR><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">14</TD><TD style="TEXT-ALIGN: right">6/24/2011 0:00</TD><TD style="TEXT-ALIGN: right">140</TD><TD style="TEXT-ALIGN: right">15</TD><TD style="TEXT-ALIGN: right">77437</TD><TD style="TEXT-ALIGN: right">34</TD></TR><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">15</TD><TD style="TEXT-ALIGN: right">6/24/2011 0:00</TD><TD style="TEXT-ALIGN: right">140</TD><TD style="TEXT-ALIGN: right">10</TD><TD style="TEXT-ALIGN: right">58022</TD><TD style="TEXT-ALIGN: right">53</TD></TR><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">16</TD><TD style="TEXT-ALIGN: right">6/24/2011 0:00</TD><TD style="TEXT-ALIGN: right">191</TD><TD style="TEXT-ALIGN: right">10</TD><TD style="TEXT-ALIGN: right">24070</TD><TD style="TEXT-ALIGN: right">12</TD></TR><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">17</TD><TD style="TEXT-ALIGN: right">6/24/2011 0:00</TD><TD style="TEXT-ALIGN: right">191</TD><TD style="TEXT-ALIGN: right">15</TD><TD style="TEXT-ALIGN: right">36010</TD><TD style="TEXT-ALIGN: right">19</TD></TR></TBODY></TABLE>

Sheet3​

Try this array formula**:

G2 = 6/23/2011
H2 = 114

=MIN(IF(A2:A17=G2,IF(B2:B17=H2,D2:D17)))

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.