Lookup With 3 Criteria

muhammad susanto

muhammad susanto

Well-known Member
Joined
Jan 8, 2013
Messages
2,102
Office Version
  1. 365
  2. 2021
Platform
  1. Windows
hello all...

how to solve lookup data this below :
<!-- Please do not remove this header -->
<!-- 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" cellpadding="0">
<tr>
<td rowspan="2" bgcolor="#EBF1DE" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">age of year</font></td>
<td colspan="5" bgcolor="#8DB4E2" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">asphalt</font></td>
<td colspan="5" bgcolor="#8DB4E2" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">interblock</font></td>
</tr>
<tr>
<td bgcolor="#C4BD97" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Excelellent</font></td>
<td bgcolor="#C4BD97" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Good</font></td>
<td bgcolor="#C4BD97" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Enough</font></td>
<td bgcolor="#C4BD97" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Bad</font></td>
<td bgcolor="#C4BD97" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Worst</font></td>
<td bgcolor="#FCD5B4" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Excelellent</font></td>
<td bgcolor="#FCD5B4" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Good</font></td>
<td bgcolor="#FCD5B4" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Enough</font></td>
<td bgcolor="#FCD5B4" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Bad</font></td>
<td bgcolor="#FCD5B4" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Worst</font></td>
</tr>
<tr>
<td bgcolor="#EBF1DE" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">0</font></td>
<td bgcolor="#C4BD97" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">0</font></td>
<td bgcolor="#C4BD97" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">0</font></td>
<td bgcolor="#C4BD97" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">0</font></td>
<td bgcolor="#C4BD97" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">0</font></td>
<td bgcolor="#C4BD97" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">0</font></td>
<td bgcolor="#FCD5B4" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">0</font></td>
<td bgcolor="#FCD5B4" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">1</font></td>
<td bgcolor="#FCD5B4" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">2</font></td>
<td bgcolor="#FCD5B4" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">1</font></td>
<td bgcolor="#FCD5B4" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">1</font></td>
</tr>
<tr>
<td bgcolor="#EBF1DE" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">1</font></td>
<td bgcolor="#C4BD97" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">4</font></td>
<td bgcolor="#C4BD97" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">5</font></td>
<td bgcolor="#C4BD97" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">6</font></td>
<td bgcolor="#C4BD97" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">7</font></td>
<td bgcolor="#C4BD97" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">8</font></td>
<td bgcolor="#FCD5B4" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">5</font></td>
<td bgcolor="#FCD5B4" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">2</font></td>
<td bgcolor="#FCD5B4" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">3</font></td>
<td bgcolor="#FCD5B4" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">12</font></td>
<td bgcolor="#FCD5B4" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">2</font></td>
</tr>
<tr>
<td bgcolor="#EBF1DE" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">2</font></td>
<td bgcolor="#C4BD97" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">8</font></td>
<td bgcolor="#C4BD97" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">9</font></td>
<td bgcolor="#C4BD97" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">10</font></td>
<td bgcolor="#C4BD97" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">12</font></td>
<td bgcolor="#C4BD97" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">14</font></td>
<td bgcolor="#FCD5B4" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">6</font></td>
<td bgcolor="#FCD5B4" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">5</font></td>
<td bgcolor="#FCD5B4" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">3</font></td>
<td bgcolor="#FCD5B4" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">15</font></td>
<td bgcolor="#FCD5B4" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">5</font></td>
</tr>
<tr>
<td bgcolor="#EBF1DE" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">3</font></td>
<td bgcolor="#C4BD97" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">11</font></td>
<td bgcolor="#C4BD97" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">13</font></td>
<td bgcolor="#C4BD97" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">14</font></td>
<td bgcolor="#C4BD97" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">17</font></td>
<td bgcolor="#C4BD97" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">20</font></td>
<td bgcolor="#FCD5B4" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">9</font></td>
<td bgcolor="#FCD5B4" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">13</font></td>
<td bgcolor="#FCD5B4" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">3</font></td>
<td bgcolor="#FCD5B4" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">17</font></td>
<td bgcolor="#FCD5B4" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">20</font></td>
</tr>
<tr>
<td bgcolor="#EBF1DE" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">4</font></td>
<td bgcolor="#C4BD97" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">14</font></td>
<td bgcolor="#C4BD97" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">15</font></td>
<td bgcolor="#C4BD97" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">18</font></td>
<td bgcolor="#C4BD97" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">22</font></td>
<td bgcolor="#C4BD97" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">25</font></td>
<td bgcolor="#FCD5B4" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">14</font></td>
<td bgcolor="#FCD5B4" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">15</font></td>
<td bgcolor="#FCD5B4" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">18</font></td>
<td bgcolor="#FCD5B4" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">22</font></td>
<td bgcolor="#FCD5B4" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">25</font></td>
</tr>
<tr>
<td bgcolor="#EBF1DE" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">5</font></td>
<td bgcolor="#C4BD97" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">16</font></td>
<td bgcolor="#C4BD97" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">18</font></td>
<td bgcolor="#C4BD97" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">22</font></td>
<td bgcolor="#C4BD97" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">26</font></td>
<td bgcolor="#C4BD97" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">30</font></td>
<td bgcolor="#FCD5B4" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">16</font></td>
<td bgcolor="#FCD5B4" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">18</font></td>
<td bgcolor="#FCD5B4" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">22</font></td>
<td bgcolor="#FCD5B4" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">26</font></td>
<td bgcolor="#FCD5B4" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">30</font></td>
</tr>
<tr>
<td bgcolor="#EBF1DE" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">6</font></td>
<td bgcolor="#C4BD97" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">16</font></td>
<td bgcolor="#C4BD97" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">21</font></td>
<td bgcolor="#C4BD97" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">26</font></td>
<td bgcolor="#C4BD97" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">30</font></td>
<td bgcolor="#C4BD97" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">35</font></td>
<td bgcolor="#FCD5B4" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">16</font></td>
<td bgcolor="#FCD5B4" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">21</font></td>
<td bgcolor="#FCD5B4" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">26</font></td>
<td bgcolor="#FCD5B4" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">30</font></td>
<td bgcolor="#FCD5B4" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">35</font></td>
</tr>
<tr>
<td bgcolor="#EBF1DE" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">7</font></td>
<td bgcolor="#C4BD97" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">16</font></td>
<td bgcolor="#C4BD97" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">24</font></td>
<td bgcolor="#C4BD97" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">29</font></td>
<td bgcolor="#C4BD97" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">34</font></td>
<td bgcolor="#C4BD97" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">39</font></td>
<td bgcolor="#FCD5B4" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">16</font></td>
<td bgcolor="#FCD5B4" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">24</font></td>
<td bgcolor="#FCD5B4" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">29</font></td>
<td bgcolor="#FCD5B4" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">34</font></td>
<td bgcolor="#FCD5B4" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">39</font></td>
</tr>
<tr>
<td bgcolor="#EBF1DE" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">8</font></td>
<td bgcolor="#C4BD97" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">16</font></td>
<td bgcolor="#C4BD97" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">27</font></td>
<td bgcolor="#C4BD97" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">32</font></td>
<td bgcolor="#C4BD97" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">38</font></td>
<td bgcolor="#C4BD97" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">43</font></td>
<td bgcolor="#FCD5B4" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">16</font></td>
<td bgcolor="#FCD5B4" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">27</font></td>
<td bgcolor="#FCD5B4" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">32</font></td>
<td bgcolor="#FCD5B4" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">38</font></td>
<td bgcolor="#FCD5B4" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">43</font></td>
</tr>
<tr>
<td bgcolor="#EBF1DE" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">9</font></td>
<td bgcolor="#C4BD97" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">16</font></td>
<td bgcolor="#C4BD97" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">31</font></td>
<td bgcolor="#C4BD97" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">35</font></td>
<td bgcolor="#C4BD97" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">41</font></td>
<td bgcolor="#C4BD97" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">47</font></td>
<td bgcolor="#FCD5B4" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">16</font></td>
<td bgcolor="#FCD5B4" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">31</font></td>
<td bgcolor="#FCD5B4" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">35</font></td>
<td bgcolor="#FCD5B4" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">41</font></td>
<td bgcolor="#FCD5B4" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">47</font></td>
</tr>
<tr>
<td bgcolor="#EBF1DE" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">10</font></td>
<td bgcolor="#C4BD97" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">16</font></td>
<td bgcolor="#C4BD97" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">34</font></td>
<td bgcolor="#C4BD97" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">38</font></td>
<td bgcolor="#C4BD97" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">44</font></td>
<td bgcolor="#C4BD97" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">50</font></td>
<td bgcolor="#FCD5B4" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">16</font></td>
<td bgcolor="#FCD5B4" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">34</font></td>
<td bgcolor="#FCD5B4" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">38</font></td>
<td bgcolor="#FCD5B4" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">44</font></td>
<td bgcolor="#FCD5B4" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">50</font></td>
</tr>
<tr>
<td bgcolor="#FFFFFF" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">etc…</font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
</tr>
<tr>
<td bgcolor="#FFFFFF" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
</tr>
<tr>
<td bgcolor="#FFFFFF" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">expectedt result</font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
</tr>
<tr>
<td bgcolor="#FFFFFF" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">age of year (Given)</font></td>
<td bgcolor="#FFFFFF" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">model (given)</font></td>
<td bgcolor="#FFFFFF" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">type (given)</font></td>
<td bgcolor="#FFFFFF" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">expected result/after formula</font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
</tr>
<tr>
<td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">2</font></td>
<td bgcolor="#FFFFFF" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">asphalt</font></td>
<td bgcolor="#FFFFFF" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">good</font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#FF0000">9</font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
</tr>
<tr>
<td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">6</font></td>
<td bgcolor="#FFFFFF" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">interblock</font></td>
<td bgcolor="#FFFFFF" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">bad</font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#FF0000">??</font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
</tr>
<tr>
<td bgcolor="#FFFFFF" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">etc…</font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
</tr>
</table>


any help thanks in advance...

m,susanto
 
Last edited:

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).
Sort by date Sort by votes

<tbody>
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=EBF1DE]#EBF1DE[/URL] , align: center"] age of year [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=8DB4E2]#8DB4E2[/URL] , colspan: 5, align: center"] asphalt [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=8DB4E2]#8DB4E2[/URL] , colspan: 5, align: center"] interblock [/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C4BD97]#C4BD97[/URL] , align: center"] Excelellent [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C4BD97]#C4BD97[/URL] , align: center"] Good [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C4BD97]#C4BD97[/URL] , align: center"] Enough [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C4BD97]#C4BD97[/URL] , align: center"] Bad [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C4BD97]#C4BD97[/URL] , align: center"] Worst [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FCD5B4]#FCD5B4[/URL] , align: center"] Excelellent [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FCD5B4]#FCD5B4[/URL] , align: center"] Good [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FCD5B4]#FCD5B4[/URL] , align: center"] Enough [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FCD5B4]#FCD5B4[/URL] , align: center"] Bad [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FCD5B4]#FCD5B4[/URL] , align: center"] Worst [/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=EBF1DE]#EBF1DE[/URL] , align: center"] 0 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C4BD97]#C4BD97[/URL] , align: right"] 0 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C4BD97]#C4BD97[/URL] , align: right"] 0 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C4BD97]#C4BD97[/URL] , align: right"] 0 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C4BD97]#C4BD97[/URL] , align: right"] 0 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C4BD97]#C4BD97[/URL] , align: right"] 0 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FCD5B4]#FCD5B4[/URL] , align: right"] 0 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FCD5B4]#FCD5B4[/URL] , align: right"] 1 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FCD5B4]#FCD5B4[/URL] , align: right"] 2 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FCD5B4]#FCD5B4[/URL] , align: right"] 1 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FCD5B4]#FCD5B4[/URL] , align: right"] 1 [/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=EBF1DE]#EBF1DE[/URL] , align: center"] 1 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C4BD97]#C4BD97[/URL] , align: right"] 4 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C4BD97]#C4BD97[/URL] , align: right"] 5 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C4BD97]#C4BD97[/URL] , align: right"] 6 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C4BD97]#C4BD97[/URL] , align: right"] 7 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C4BD97]#C4BD97[/URL] , align: right"] 8 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FCD5B4]#FCD5B4[/URL] , align: right"] 5 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FCD5B4]#FCD5B4[/URL] , align: right"] 2 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FCD5B4]#FCD5B4[/URL] , align: right"] 3 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FCD5B4]#FCD5B4[/URL] , align: right"] 12 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FCD5B4]#FCD5B4[/URL] , align: right"] 2 [/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=EBF1DE]#EBF1DE[/URL] , align: center"] 2 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C4BD97]#C4BD97[/URL] , align: right"] 8 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C4BD97]#C4BD97[/URL] , align: right"] 9 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C4BD97]#C4BD97[/URL] , align: right"] 10 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C4BD97]#C4BD97[/URL] , align: right"] 12 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C4BD97]#C4BD97[/URL] , align: right"] 14 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FCD5B4]#FCD5B4[/URL] , align: right"] 6 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FCD5B4]#FCD5B4[/URL] , align: right"] 5 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FCD5B4]#FCD5B4[/URL] , align: right"] 3 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FCD5B4]#FCD5B4[/URL] , align: right"] 15 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FCD5B4]#FCD5B4[/URL] , align: right"] 5 [/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=EBF1DE]#EBF1DE[/URL] , align: center"] 3 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C4BD97]#C4BD97[/URL] , align: right"] 11 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C4BD97]#C4BD97[/URL] , align: right"] 13 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C4BD97]#C4BD97[/URL] , align: right"] 14 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C4BD97]#C4BD97[/URL] , align: right"] 17 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C4BD97]#C4BD97[/URL] , align: right"] 20 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FCD5B4]#FCD5B4[/URL] , align: right"] 9 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FCD5B4]#FCD5B4[/URL] , align: right"] 13 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FCD5B4]#FCD5B4[/URL] , align: right"] 3 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FCD5B4]#FCD5B4[/URL] , align: right"] 17 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FCD5B4]#FCD5B4[/URL] , align: right"] 20 [/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=EBF1DE]#EBF1DE[/URL] , align: center"] 4 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C4BD97]#C4BD97[/URL] , align: right"] 14 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C4BD97]#C4BD97[/URL] , align: right"] 15 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C4BD97]#C4BD97[/URL] , align: right"] 18 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C4BD97]#C4BD97[/URL] , align: right"] 22 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C4BD97]#C4BD97[/URL] , align: right"] 25 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FCD5B4]#FCD5B4[/URL] , align: right"] 14 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FCD5B4]#FCD5B4[/URL] , align: right"] 15 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FCD5B4]#FCD5B4[/URL] , align: right"] 18 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FCD5B4]#FCD5B4[/URL] , align: right"] 22 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FCD5B4]#FCD5B4[/URL] , align: right"] 25 [/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=EBF1DE]#EBF1DE[/URL] , align: center"] 5 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C4BD97]#C4BD97[/URL] , align: right"] 16 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C4BD97]#C4BD97[/URL] , align: right"] 18 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C4BD97]#C4BD97[/URL] , align: right"] 22 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C4BD97]#C4BD97[/URL] , align: right"] 26 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C4BD97]#C4BD97[/URL] , align: right"] 30 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FCD5B4]#FCD5B4[/URL] , align: right"] 16 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FCD5B4]#FCD5B4[/URL] , align: right"] 18 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FCD5B4]#FCD5B4[/URL] , align: right"] 22 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FCD5B4]#FCD5B4[/URL] , align: right"] 26 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FCD5B4]#FCD5B4[/URL] , align: right"] 30 [/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=EBF1DE]#EBF1DE[/URL] , align: center"] 6 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C4BD97]#C4BD97[/URL] , align: right"] 16 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C4BD97]#C4BD97[/URL] , align: right"] 21 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C4BD97]#C4BD97[/URL] , align: right"] 26 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C4BD97]#C4BD97[/URL] , align: right"] 30 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C4BD97]#C4BD97[/URL] , align: right"] 35 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FCD5B4]#FCD5B4[/URL] , align: right"] 16 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FCD5B4]#FCD5B4[/URL] , align: right"] 21 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FCD5B4]#FCD5B4[/URL] , align: right"] 26 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FCD5B4]#FCD5B4[/URL] , align: right"] 30 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FCD5B4]#FCD5B4[/URL] , align: right"] 35 [/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=EBF1DE]#EBF1DE[/URL] , align: center"] 7 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C4BD97]#C4BD97[/URL] , align: right"] 16 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C4BD97]#C4BD97[/URL] , align: right"] 24 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C4BD97]#C4BD97[/URL] , align: right"] 29 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C4BD97]#C4BD97[/URL] , align: right"] 34 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C4BD97]#C4BD97[/URL] , align: right"] 39 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FCD5B4]#FCD5B4[/URL] , align: right"] 16 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FCD5B4]#FCD5B4[/URL] , align: right"] 24 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FCD5B4]#FCD5B4[/URL] , align: right"] 29 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FCD5B4]#FCD5B4[/URL] , align: right"] 34 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FCD5B4]#FCD5B4[/URL] , align: right"] 39 [/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=EBF1DE]#EBF1DE[/URL] , align: center"] 8 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C4BD97]#C4BD97[/URL] , align: right"] 16 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C4BD97]#C4BD97[/URL] , align: right"] 27 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C4BD97]#C4BD97[/URL] , align: right"] 32 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C4BD97]#C4BD97[/URL] , align: right"] 38 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C4BD97]#C4BD97[/URL] , align: right"] 43 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FCD5B4]#FCD5B4[/URL] , align: right"] 16 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FCD5B4]#FCD5B4[/URL] , align: right"] 27 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FCD5B4]#FCD5B4[/URL] , align: right"] 32 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FCD5B4]#FCD5B4[/URL] , align: right"] 38 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FCD5B4]#FCD5B4[/URL] , align: right"] 43 [/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=EBF1DE]#EBF1DE[/URL] , align: center"] 9 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C4BD97]#C4BD97[/URL] , align: right"] 16 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C4BD97]#C4BD97[/URL] , align: right"] 31 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C4BD97]#C4BD97[/URL] , align: right"] 35 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C4BD97]#C4BD97[/URL] , align: right"] 41 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C4BD97]#C4BD97[/URL] , align: right"] 47 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FCD5B4]#FCD5B4[/URL] , align: right"] 16 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FCD5B4]#FCD5B4[/URL] , align: right"] 31 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FCD5B4]#FCD5B4[/URL] , align: right"] 35 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FCD5B4]#FCD5B4[/URL] , align: right"] 41 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FCD5B4]#FCD5B4[/URL] , align: right"] 47 [/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=EBF1DE]#EBF1DE[/URL] , align: center"] 10 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C4BD97]#C4BD97[/URL] , align: right"] 16 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C4BD97]#C4BD97[/URL] , align: right"] 34 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C4BD97]#C4BD97[/URL] , align: right"] 38 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C4BD97]#C4BD97[/URL] , align: right"] 44 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C4BD97]#C4BD97[/URL] , align: right"] 50 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FCD5B4]#FCD5B4[/URL] , align: right"] 16 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FCD5B4]#FCD5B4[/URL] , align: right"] 34 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FCD5B4]#FCD5B4[/URL] , align: right"] 38 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FCD5B4]#FCD5B4[/URL] , align: right"] 44 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FCD5B4]#FCD5B4[/URL] , align: right"] 50 [/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: center"] etc… [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"] [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"] [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"] [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"] [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"] [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"] [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"] [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"] [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"] [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"] [/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: center"] [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"] [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"] [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"] [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"] [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"] [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"] [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"] [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"] [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"] [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"] [/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "] expectedt result [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"] [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"] [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"] [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"] [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"] [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"] [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"] [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"] [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"] [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"] [/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: center"] age of year (Given) [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: center"] model (given) [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "] type (given) [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "] expected result/after formula [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"] [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"] [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"] [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"] [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"] [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"] [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"] [/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"] 2 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "] asphalt [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "] good [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"] 9 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"] [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"] [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"] [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"] [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"] [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"] [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"] [/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"] 6 [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "] interblock [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "] bad [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"] ?? [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"] [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"] [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"] [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"] [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"] [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"] [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"] [/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: center"] etc… [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"] [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"] [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"] [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"] [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"] [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"] [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"] [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"] [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"] [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] , align: right"] [/TD]

</tbody>
any help thanks in advance...

m,susanto
 
Upvote 0
[TABLE="class: grid"]
<tbody>[TR]
[TD]Row\Col[/TD]
[TD]
A​
[/TD]
[TD]
B​
[/TD]
[TD]
C​
[/TD]
[TD]
D​
[/TD]
[TD]
E​
[/TD]
[TD]
F​
[/TD]
[TD]
G​
[/TD]
[TD]
H​
[/TD]
[TD]
I​
[/TD]
[TD]
J​
[/TD]
[TD]
K​
[/TD]
[/TR]
[TR]
[TD]
1​
[/TD]
[TD="bgcolor: #EBF1DE"]age of year[/TD]
[TD="bgcolor: #8DB4E2"]asphalt[/TD]
[TD="bgcolor: #8DB4E2"][/TD]
[TD="bgcolor: #8DB4E2"][/TD]
[TD="bgcolor: #8DB4E2"][/TD]
[TD="bgcolor: #8DB4E2"][/TD]
[TD="bgcolor: #8DB4E2"]interblock[/TD]
[TD="bgcolor: #8DB4E2"][/TD]
[TD="bgcolor: #8DB4E2"][/TD]
[TD="bgcolor: #8DB4E2"][/TD]
[TD="bgcolor: #8DB4E2"][/TD]
[/TR]
[TR]
[TD]
2​
[/TD]
[TD="bgcolor: #EBF1DE"][/TD]
[TD="bgcolor: #C4BD97"]Excellent[/TD]
[TD="bgcolor: #C4BD97"]Good[/TD]
[TD="bgcolor: #C4BD97"]Enough[/TD]
[TD="bgcolor: #C4BD97"]Bad[/TD]
[TD="bgcolor: #C4BD97"]Worst[/TD]
[TD="bgcolor: #FCD5B4"]Excellent[/TD]
[TD="bgcolor: #FCD5B4"]Good[/TD]
[TD="bgcolor: #FCD5B4"]Enough[/TD]
[TD="bgcolor: #FCD5B4"]Bad[/TD]
[TD="bgcolor: #FCD5B4"]Worst[/TD]
[/TR]
[TR]
[TD]
3​
[/TD]
[TD="bgcolor: #EBF1DE"]
0​
[/TD]
[TD="bgcolor: #C4BD97"]
0​
[/TD]
[TD="bgcolor: #C4BD97"]
0​
[/TD]
[TD="bgcolor: #C4BD97"]
0​
[/TD]
[TD="bgcolor: #C4BD97"]
0​
[/TD]
[TD="bgcolor: #C4BD97"]
0​
[/TD]
[TD="bgcolor: #FCD5B4"]
0​
[/TD]
[TD="bgcolor: #FCD5B4"]
1​
[/TD]
[TD="bgcolor: #FCD5B4"]
2​
[/TD]
[TD="bgcolor: #FCD5B4"]
1​
[/TD]
[TD="bgcolor: #FCD5B4"]
1​
[/TD]
[/TR]
[TR]
[TD]
4​
[/TD]
[TD="bgcolor: #EBF1DE"]
1​
[/TD]
[TD="bgcolor: #C4BD97"]
4​
[/TD]
[TD="bgcolor: #C4BD97"]
5​
[/TD]
[TD="bgcolor: #C4BD97"]
6​
[/TD]
[TD="bgcolor: #C4BD97"]
7​
[/TD]
[TD="bgcolor: #C4BD97"]
8​
[/TD]
[TD="bgcolor: #FCD5B4"]
5​
[/TD]
[TD="bgcolor: #FCD5B4"]
2​
[/TD]
[TD="bgcolor: #FCD5B4"]
3​
[/TD]
[TD="bgcolor: #FCD5B4"]
12​
[/TD]
[TD="bgcolor: #FCD5B4"]
2​
[/TD]
[/TR]
[TR]
[TD]
5​
[/TD]
[TD="bgcolor: #EBF1DE"]
2​
[/TD]
[TD="bgcolor: #C4BD97"]
8​
[/TD]
[TD="bgcolor: #C4BD97"]
9​
[/TD]
[TD="bgcolor: #C4BD97"]
10​
[/TD]
[TD="bgcolor: #C4BD97"]
12​
[/TD]
[TD="bgcolor: #C4BD97"]
14​
[/TD]
[TD="bgcolor: #FCD5B4"]
6​
[/TD]
[TD="bgcolor: #FCD5B4"]
5​
[/TD]
[TD="bgcolor: #FCD5B4"]
3​
[/TD]
[TD="bgcolor: #FCD5B4"]
15​
[/TD]
[TD="bgcolor: #FCD5B4"]
5​
[/TD]
[/TR]
[TR]
[TD]
6​
[/TD]
[TD="bgcolor: #EBF1DE"]
3​
[/TD]
[TD="bgcolor: #C4BD97"]
11​
[/TD]
[TD="bgcolor: #C4BD97"]
13​
[/TD]
[TD="bgcolor: #C4BD97"]
14​
[/TD]
[TD="bgcolor: #C4BD97"]
17​
[/TD]
[TD="bgcolor: #C4BD97"]
20​
[/TD]
[TD="bgcolor: #FCD5B4"]
9​
[/TD]
[TD="bgcolor: #FCD5B4"]
13​
[/TD]
[TD="bgcolor: #FCD5B4"]
3​
[/TD]
[TD="bgcolor: #FCD5B4"]
17​
[/TD]
[TD="bgcolor: #FCD5B4"]
20​
[/TD]
[/TR]
[TR]
[TD]
7​
[/TD]
[TD="bgcolor: #EBF1DE"]
4​
[/TD]
[TD="bgcolor: #C4BD97"]
14​
[/TD]
[TD="bgcolor: #C4BD97"]
15​
[/TD]
[TD="bgcolor: #C4BD97"]
18​
[/TD]
[TD="bgcolor: #C4BD97"]
22​
[/TD]
[TD="bgcolor: #C4BD97"]
25​
[/TD]
[TD="bgcolor: #FCD5B4"]
14​
[/TD]
[TD="bgcolor: #FCD5B4"]
15​
[/TD]
[TD="bgcolor: #FCD5B4"]
18​
[/TD]
[TD="bgcolor: #FCD5B4"]
22​
[/TD]
[TD="bgcolor: #FCD5B4"]
25​
[/TD]
[/TR]
[TR]
[TD]
8​
[/TD]
[TD="bgcolor: #EBF1DE"]
5​
[/TD]
[TD="bgcolor: #C4BD97"]
16​
[/TD]
[TD="bgcolor: #C4BD97"]
18​
[/TD]
[TD="bgcolor: #C4BD97"]
22​
[/TD]
[TD="bgcolor: #C4BD97"]
26​
[/TD]
[TD="bgcolor: #C4BD97"]
30​
[/TD]
[TD="bgcolor: #FCD5B4"]
16​
[/TD]
[TD="bgcolor: #FCD5B4"]
18​
[/TD]
[TD="bgcolor: #FCD5B4"]
22​
[/TD]
[TD="bgcolor: #FCD5B4"]
26​
[/TD]
[TD="bgcolor: #FCD5B4"]
30​
[/TD]
[/TR]
[TR]
[TD]
9​
[/TD]
[TD="bgcolor: #EBF1DE"]
6​
[/TD]
[TD="bgcolor: #C4BD97"]
16​
[/TD]
[TD="bgcolor: #C4BD97"]
21​
[/TD]
[TD="bgcolor: #C4BD97"]
26​
[/TD]
[TD="bgcolor: #C4BD97"]
30​
[/TD]
[TD="bgcolor: #C4BD97"]
35​
[/TD]
[TD="bgcolor: #FCD5B4"]
16​
[/TD]
[TD="bgcolor: #FCD5B4"]
21​
[/TD]
[TD="bgcolor: #FCD5B4"]
26​
[/TD]
[TD="bgcolor: #FCD5B4"]
30​
[/TD]
[TD="bgcolor: #FCD5B4"]
35​
[/TD]
[/TR]
[TR]
[TD]
10​
[/TD]
[TD="bgcolor: #EBF1DE"]
7​
[/TD]
[TD="bgcolor: #C4BD97"]
16​
[/TD]
[TD="bgcolor: #C4BD97"]
24​
[/TD]
[TD="bgcolor: #C4BD97"]
29​
[/TD]
[TD="bgcolor: #C4BD97"]
34​
[/TD]
[TD="bgcolor: #C4BD97"]
39​
[/TD]
[TD="bgcolor: #FCD5B4"]
16​
[/TD]
[TD="bgcolor: #FCD5B4"]
24​
[/TD]
[TD="bgcolor: #FCD5B4"]
29​
[/TD]
[TD="bgcolor: #FCD5B4"]
34​
[/TD]
[TD="bgcolor: #FCD5B4"]
39​
[/TD]
[/TR]
[TR]
[TD]
11​
[/TD]
[TD="bgcolor: #EBF1DE"]
8​
[/TD]
[TD="bgcolor: #C4BD97"]
16​
[/TD]
[TD="bgcolor: #C4BD97"]
27​
[/TD]
[TD="bgcolor: #C4BD97"]
32​
[/TD]
[TD="bgcolor: #C4BD97"]
38​
[/TD]
[TD="bgcolor: #C4BD97"]
43​
[/TD]
[TD="bgcolor: #FCD5B4"]
16​
[/TD]
[TD="bgcolor: #FCD5B4"]
27​
[/TD]
[TD="bgcolor: #FCD5B4"]
32​
[/TD]
[TD="bgcolor: #FCD5B4"]
38​
[/TD]
[TD="bgcolor: #FCD5B4"]
43​
[/TD]
[/TR]
[TR]
[TD]
12​
[/TD]
[TD="bgcolor: #EBF1DE"]
9​
[/TD]
[TD="bgcolor: #C4BD97"]
16​
[/TD]
[TD="bgcolor: #C4BD97"]
31​
[/TD]
[TD="bgcolor: #C4BD97"]
35​
[/TD]
[TD="bgcolor: #C4BD97"]
41​
[/TD]
[TD="bgcolor: #C4BD97"]
47​
[/TD]
[TD="bgcolor: #FCD5B4"]
16​
[/TD]
[TD="bgcolor: #FCD5B4"]
31​
[/TD]
[TD="bgcolor: #FCD5B4"]
35​
[/TD]
[TD="bgcolor: #FCD5B4"]
41​
[/TD]
[TD="bgcolor: #FCD5B4"]
47​
[/TD]
[/TR]
[TR]
[TD]
13​
[/TD]
[TD="bgcolor: #EBF1DE"]
10​
[/TD]
[TD="bgcolor: #C4BD97"]
16​
[/TD]
[TD="bgcolor: #C4BD97"]
34​
[/TD]
[TD="bgcolor: #C4BD97"]
38​
[/TD]
[TD="bgcolor: #C4BD97"]
44​
[/TD]
[TD="bgcolor: #C4BD97"]
50​
[/TD]
[TD="bgcolor: #FCD5B4"]
16​
[/TD]
[TD="bgcolor: #FCD5B4"]
34​
[/TD]
[TD="bgcolor: #FCD5B4"]
38​
[/TD]
[TD="bgcolor: #FCD5B4"]
44​
[/TD]
[TD="bgcolor: #FCD5B4"]
50​
[/TD]
[/TR]
[TR]
[TD]
14​
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]
15​
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]
16​
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]
17​
[/TD]
[TD]age[/TD]
[TD]model[/TD]
[TD]type[/TD]
[TD]score[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]
18​
[/TD]
[TD]
2​
[/TD]
[TD]asphalt[/TD]
[TD]good[/TD]
[TD]
9​
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]
19​
[/TD]
[TD]
6​
[/TD]
[TD]interblock[/TD]
[TD]bad[/TD]
[TD]
30​
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]
20​
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


Define age in the Name Manager as referring to: Sheet1!$A$2:$A$13.
Define asphalt in the Name Manager as referring to: =Sheet1!$B$3:$F$13.
Define interblock in the Name Manager as referring to: =Sheet1!$G$3:$K$13.

In D18 enter and copy down:

=VLOOKUP(A18,CHOOSE({1,2},age,INDEX(INDIRECT($B18),0,MATCH($C18,{"Excellent","Good","Enough","Bad","Worst"},0))),2,0)
 
Upvote 0
Another option,

In D18, copied down :

=INDEX((B$3:F$13,G$3:K$13),MATCH(A18,A$3:A$13,0),MATCH(C18,B$2:F$2,0),MATCH(B18,{"asphalt","interblock"},0))

Regards
Bosco
 
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
649
smozgur
smozgur
E
  • Question Question
VBA code clean up
Replies
9
Views
593
mumps
mumps
C
  • Solved
Excel 2016 32bit VBA Pulling info from Website to Sheet
Replies
2
Views
2K
CrashOD
C
E
  • Question Question
Adding a custom message.
Replies
1
Views
671
Micron
M
D
  • Question Question
Looking for a way to allocate shifts between teams, maybe a LET formula
Replies
0
Views
90
Dazzybeeguy
D

Forum statistics

Threads
1,224,827
Messages
6,181,195
Members
453,021
Latest member
pingpong7117

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