Find highest and lowest numbers based on criteria

[baleshst]

In the below table
Request you to provide the formulas in yellow cells based on the following criteria

Highest Footfalls with its relevant date after ignoring blank cells, cells with zero value and cells with any
Lowest Footfalls with its relevant date after ignoring blank cells, cells with zero value and cells with any


<!-- Please do not remove this header -->
<!-- Table easily created from Excel with ASAP Utilities (http://www.asap-utilities.com) -->
<table border="1" bordercolor="#C0C0C0" bordercolordark="#FFFFFF" cellspacing="0">
<tr>
<th bgcolor="#FFFFFF" width="63" height="25" valign="bottom"><font face="Tahoma" size="2" color="#000000"><b>Date</b></font></th>
<th bgcolor="#FFFFFF" width="63" height="25" valign="bottom"><font face="Tahoma" size="2" color="#000000"><b>Footfalls</b></font></th>
</tr>
<tr>
<td bgcolor="#FFFFFF" width="63" height="25" valign="bottom"><font face="Tahoma" size="2" color="#000000">01-04-14</font></td>
<td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="bottom"><font face="Tahoma" size="2" color="#000000">14</font></td>
</tr>
<tr>
<td bgcolor="#FFFFFF" width="63" height="25" valign="bottom"><font face="Tahoma" size="2" color="#000000">02-04-14</font></td>
<td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="bottom"><font face="Tahoma" size="2" color="#000000">34</font></td>
</tr>
<tr>
<td bgcolor="#FFFFFF" width="63" height="25" valign="bottom"><font face="Tahoma" size="2" color="#000000">03-04-14</font></td>
<td bgcolor="#FFFFFF" width="63" height="25" valign="bottom"><font face="Tahoma" size="2" color="#000000">#DIV/0!</font></td>
</tr>
<tr>
<td bgcolor="#FFFFFF" width="63" height="25" valign="bottom"><font face="Tahoma" size="2" color="#000000">04-04-14</font></td>
<td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="bottom"><font face="Tahoma" size="2" color="#000000">0</font></td>
</tr>
<tr>
<td bgcolor="#FFFFFF" width="63" height="25" valign="bottom"><font face="Tahoma" size="2" color="#000000">05-04-14</font></td>
<td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="bottom"><font face="Tahoma" size="2" color="#000000"></font></td>
</tr>
<tr>
<td bgcolor="#FFFFFF" width="63" height="25" valign="bottom"><font face="Tahoma" size="2" color="#000000">06-04-14</font></td>
<td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="bottom"><font face="Tahoma" size="2" color="#000000">16</font></td>
</tr>
<tr>
<td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="bottom"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="bottom"><font face="Tahoma" size="2" color="#000000"></font></td>
</tr>
<tr>
<td bgcolor="#FFFFFF" width="63" height="25" valign="bottom"><font face="Tahoma" size="2" color="#000000"><b>Highest</b></font></td>
<td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="bottom"><font face="Tahoma" size="2" color="#000000"></font></td>
</tr>
<tr>
<td bgcolor="#FFFFFF" width="63" height="25" valign="bottom"><font face="Tahoma" size="2" color="#000000">Date</font></td>
<td bgcolor="#FFFFFF" width="63" height="25" valign="bottom"><font face="Tahoma" size="2" color="#000000">Footfalls</font></td>
</tr>
<tr>
<td bgcolor="#FFFF00" width="63" height="25" align="right" valign="bottom"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFF00" width="63" height="25" align="right" valign="bottom"><font face="Tahoma" size="2" color="#000000"></font></td>
</tr>
<tr>
<td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="bottom"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="bottom"><font face="Tahoma" size="2" color="#000000"></font></td>
</tr>
<tr>
<td bgcolor="#FFFFFF" width="63" height="25" valign="bottom"><font face="Tahoma" size="2" color="#000000"><b>Lowest</b></font></td>
<td bgcolor="#FFFFFF" width="63" height="25" align="right" valign="bottom"><font face="Tahoma" size="2" color="#000000"></font></td>
</tr>
<tr>
<td bgcolor="#FFFFFF" width="63" height="25" valign="bottom"><font face="Tahoma" size="2" color="#000000">Date</font></td>
<td bgcolor="#FFFFFF" width="63" height="25" valign="bottom"><font face="Tahoma" size="2" color="#000000">Footfalls</font></td>
</tr>
<tr>
<td bgcolor="#FFFF00" width="63" height="25" align="right" valign="bottom"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFF00" width="63" height="25" align="right" valign="bottom"><font face="Tahoma" size="2" color="#000000"></font></td>
</tr>
</table>

 

[steve the fish]

Placing table in A1:B15:

In B11: =MAX(IF(ISNUMBER(B2:B7),B2:B7))
In B15: =MIN(IF(ISNUMBER(B2:B7),IF(B2:B7>0,B2:B7)))

Both confirmed with CNTL-SHIFT-ENTER not just ENTER

In A11: =INDEX(A2:A7,MATCH(B11,B2:B7,0))
In A15: =INDEX(A2:A7,MATCH(B15,B2:B7,0))

These find first match date in event of ties.