This is my solution
let me know!
<table border="1" cellspacing="0" cellpadding="0" style="font-family:Calibri,Arial; font-size:14pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "> <colgroup><col style="width:30px; " /><col style="width:98.4px;" /><col style="width:143.2px;" /><col style="width:93.6px;" /><col style="width:52px;" /><col style="width:98.4px;" /><col style="width:172px;" /><col style="width:93.6px;" /></colgroup><tr style="background-color:#cacaca; text-align:center;font-size:8pt; "><td > </td><td style=" border-width:3px; border-style:solid;border-color:#f0f0f0; ">A</td><td style=" border-width:3px; border-style:solid;border-color:#f0f0f0; ">B</td><td style=" border-width:3px; border-style:solid;border-color:#f0f0f0; ">C</td><td style=" border-width:3px; border-style:solid;border-color:#f0f0f0; ">D</td><td style=" border-width:3px; border-style:solid;border-color:#f0f0f0; ">E</td><td style=" border-width:3px; border-style:solid;border-color:#f0f0f0; ">F</td><td style=" border-width:3px; border-style:solid;border-color:#f0f0f0; ">G</td></tr><tr style="height:21px ;" ><td style="border-width:3; border-style:solid;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >1</td><td style="color:#ff0000; ">List1</td><td > </td><td > </td><td > </td><td style="color:#ff0000; ">List 2</td><td > </td><td > </td></tr><tr style="height:21px ;" ><td style="border-width:3; border-style:solid;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >2</td><td style="background-color:#ffff00; ">Date</td><td style="background-color:#ffff00; ">Description</td><td style="background-color:#ffff00; ">Value</td><td > </td><td style="background-color:#ff0000; color:#ffffff; ">Date</td><td style="background-color:#ff0000; color:#ffffff; ">Description</td><td style="background-color:#ff0000; color:#ffffff; ">Value</td></tr><tr style="height:21px ;" ><td style="border-width:3; border-style:solid;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >3</td><td style="text-align:right; ">01/12/2014</td><td >Invoice 6746</td><td style="text-align:right; ">75,000.00</td><td > </td><td style="text-align:right; ">01/12/2014</td><td >Invoice 6746</td><td style="text-align:right; ">75,000.00</td></tr><tr style="height:21px ;" ><td style="border-width:3; border-style:solid;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >4</td><td style="text-align:right; ">01/12/2014</td><td >Invoice 3435</td><td style="text-align:right; ">25,000.00</td><td > </td><td style="text-align:right; ">01/12/2014</td><td >Invoice 3435</td><td style="text-align:right; ">25,000.00</td></tr><tr style="height:21px ;" ><td style="border-width:3; border-style:solid;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >5</td><td style="text-align:right; ">02/12/2014</td><td >Invoice 5088</td><td style="text-align:right; ">37,500.00</td><td > </td><td style="text-align:right; ">02/12/2014</td><td >Invoice 5088</td><td style="text-align:right; ">37,500.00</td></tr><tr style="height:21px ;" ><td style="border-width:3; border-style:solid;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >6</td><td style="text-align:right; ">03/12/2014</td><td >NOR AVAILABLE</td><td style="text-align:right; ">85,250.00</td><td > </td><td style="text-align:right; ">03/12/2014</td><td >Invoice 9060</td><td style="text-align:right; ">97,500.00</td></tr><tr style="height:21px ;" ><td style="border-width:3; border-style:solid;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >7</td><td style="text-align:right; ">04/12/2014</td><td >Invoice 9929</td><td style="text-align:right; ">25,000.00</td><td > </td><td style="text-align:right; ">04/12/2014</td><td >Invoice 9929</td><td style="text-align:right; ">25,000.00</td></tr><tr style="height:21px ;" ><td style="border-width:3; border-style:solid;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >8</td><td style="text-align:right; ">05/12/2014</td><td >Invoice 8676</td><td style="text-align:right; ">25,000.00</td><td > </td><td style="text-align:right; ">05/12/2014</td><td >Invoice 8676</td><td style="text-align:right; ">25,000.00</td></tr><tr style="height:21px ;" ><td style="border-width:3; border-style:solid;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >9</td><td style="text-align:right; ">06/12/2014</td><td >Invoice 1296</td><td style="text-align:right; ">100,000.00</td><td > </td><td style="text-align:right; ">06/12/2014</td><td >Invoice 1296</td><td style="text-align:right; ">100,000.00</td></tr><tr style="height:21px ;" ><td style="border-width:3; border-style:solid;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >10</td><td style="text-align:right; ">07/12/2014</td><td >Invoice 2951</td><td style="text-align:right; ">35,500.00</td><td > </td><td style="text-align:right; ">07/12/2014</td><td >Invoice 2951</td><td style="text-align:right; ">35,500.00</td></tr><tr style="height:21px ;" ><td style="border-width:3; border-style:solid;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >11</td><td style="text-align:right; ">08/12/2014</td><td >Invoice 1763</td><td style="text-align:right; ">59,750.00</td><td > </td><td style="text-align:right; ">08/12/2014</td><td >Invoice 1763</td><td style="text-align:right; ">59,750.00</td></tr><tr style="height:21px ;" ><td style="border-width:3; border-style:solid;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >12</td><td style="text-align:right; ">09/12/2014</td><td >Invoice 1341</td><td style="text-align:right; ">13,250.00</td><td > </td><td style="text-align:right; ">09/12/2014</td><td >Invoice 1341</td><td style="text-align:right; ">13,250.00</td></tr><tr style="height:21px ;" ><td style="border-width:3; border-style:solid;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >13</td><td style="text-align:right; ">10/12/2014</td><td >Invoice 9582</td><td style="text-align:right; ">75,000.00</td><td > </td><td style="text-align:right; ">10/12/2014</td><td >Invoice 9164</td><td style="text-align:right; ">75,500.00</td></tr><tr style="height:21px ;" ><td style="border-width:3; border-style:solid;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >14</td><td style="text-align:right; ">11/12/2014</td><td >Invoice 8952</td><td style="text-align:right; ">45,500.00</td><td > </td><td style="text-align:right; ">11/12/2014</td><td >Invoice 8952</td><td style="text-align:right; ">45,500.00</td></tr><tr style="height:21px ;" ><td style="border-width:3; border-style:solid;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >15</td><td style="text-align:right; ">12/12/2014</td><td >Invoice 4150</td><td style="text-align:right; ">75,000.00</td><td > </td><td style="text-align:right; ">12/12/2014</td><td >Invoice 9582</td><td style="text-align:right; ">75,000.00</td></tr><tr style="height:21px ;" ><td style="border-width:3; border-style:solid;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >16</td><td style="text-align:right; ">13/12/2014</td><td >Invoice 9634</td><td style="text-align:right; ">73,250.00</td><td > </td><td style="text-align:right; ">13/12/2014</td><td >Invoice 9634</td><td style="text-align:right; ">73,250.00</td></tr><tr style="height:21px ;" ><td style="border-width:3; border-style:solid;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >17</td><td style="text-align:right; ">14/12/2014</td><td >Invoice 7258</td><td style="text-align:right; ">25,500.00</td><td > </td><td style="text-align:right; ">14/12/2014</td><td >Invoice 7258</td><td style="text-align:right; ">25,500.00</td></tr><tr style="height:21px ;" ><td style="border-width:3; border-style:solid;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >18</td><td style="text-align:right; ">15/12/2014</td><td >Invoice 5549</td><td style="text-align:right; ">94,500.00</td><td > </td><td style="text-align:right; ">15/12/2014</td><td >Invoice 5549</td><td style="text-align:right; ">94,500.00</td></tr><tr style="height:21px ;" ><td style="border-width:3; border-style:solid;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >19</td><td style="text-align:right; ">16/12/2014</td><td >Invoice 3763</td><td style="text-align:right; ">35,500.00</td><td > </td><td style="text-align:right; ">15/12/2014</td><td >Invoice 3763</td><td style="text-align:right; ">35,500.00</td></tr><tr style="height:21px ;" ><td style="border-width:3; border-style:solid;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >20</td><td style="text-align:right; ">17/12/2014</td><td >NOR AVAILABLE</td><td style="text-align:right; ">75,000.00</td><td > </td><td style="text-align:right; ">15/12/2014</td><td >Invoice 4150</td><td style="text-align:right; ">75,000.00</td></tr><tr style="height:21px ;" ><td style="border-width:3; border-style:solid;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >21</td><td style="text-align:right; ">18/12/2014</td><td >Invoice 1524</td><td style="text-align:right; ">54,000.00</td><td > </td><td style="text-align:right; ">15/12/2014</td><td >Invoice 1524</td><td style="text-align:right; ">54,000.00</td></tr><tr style="height:21px ;" ><td style="border-width:3; border-style:solid;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >22</td><td > </td><td > </td><td > </td><td > </td><td style="text-align:right; ">15/12/2014</td><td >Invoice 7517</td><td style="text-align:right; ">92,750.00</td></tr><tr style="height:21px ;" ><td style="border-width:3; border-style:solid;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >23</td><td > </td><td > </td><td > </td><td > </td><td style="text-align:right; ">16/12/2014</td><td >Invoice 8122</td><td style="text-align:right; ">57,500.00</td></tr><tr style="height:21px ;" ><td style="border-width:3; border-style:solid;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >24</td><td > </td><td > </td><td > </td><td > </td><td style="text-align:right; ">16/12/2014</td><td >Invoice 3620</td><td style="text-align:right; ">73,750.00</td></tr><tr style="height:21px ;" ><td style="border-width:3; border-style:solid;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >25</td><td > </td><td > </td><td > </td><td > </td><td style="text-align:right; ">17/12/2014</td><td >Invoice 2231</td><td style="text-align:right; ">25,000.00</td></tr><tr style="height:21px ;" ><td style="border-width:3; border-style:solid;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >26</td><td > </td><td > </td><td > </td><td > </td><td style="text-align:right; ">17/12/2014</td><td >Invoice 9578</td><td style="text-align:right; ">50,250.00</td></tr><tr style="height:21px ;" ><td style="border-width:3; border-style:solid;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >27</td><td > </td><td > </td><td > </td><td > </td><td style="text-align:right; ">18/12/2014</td><td >Invoice 2501</td><td style="text-align:right; ">78,750.00</td></tr></table><br /><table style="font-family:Arial; font-size:10pt; border-style: groove ;border-color:#00ff00;background-color:#fffcf9; color:#000000; "><tr><td ><b>Spreadsheet Formulas</b></td></tr><tr><td ><table border = "1" cellspacing="0" cellpadding="2" style="font-family:Arial; font-size:9pt;"><tr style="background-color:#cacaca; font-size:10pt;"><td >Cell</td><td >Formula</td></tr><tr><td >B3</td><td >{=IFERROR(INDEX<span style=' color:008000; '>($F$3:$F$27,SMALL<span style=' color:#0000ff; '>(IF<span style=' color:#ff0000; '>($G$3:$G$27=C3,ROW<span style=' color:#804000; '>($G$3:$G$27)</span>-ROW<span style=' color:#804000; '>($G$3)</span>+1)</span>,COUNTIF<span style=' color:#ff0000; '>($C$3:C3,C3)</span>)</span>)</span>,"NOR AVAILABLE")}</td></tr></table></td></tr><tr><td ><span style=' font-family:Arial,Arial; font-size:9pt; font-weight:bold;'>Formula Array:</span><span style=' font-family:Arial,Arial; font-size:9pt;'><br />Produce enclosing </span><span style=' font-family:Arial,Arial; font-size:9pt; font-weight:bold;'>{ }</span><span style=' font-family:Arial,Arial; font-size:9pt;'> by entering<br />formula with CTRL+SHIFT+ENTER!</span></td></tr><tr><td >
Matrix verstehen</td></tr></table> <br />
Excel tables to the web - Excel Jeanie Html 4