PDA

Vollständige Version anzeigen : Excel Matrix Suche


overmas
06.04.2012, 16:11
Ich habe eine Tablle /Matrix 3x7, z.b. steht in der oberen zeile Baujahr und in der Spalte die gelaufenen Kilometer, aus der Kombination ergibt sich in der Matrix jeweils der Preis

nun ist meine frage wenn ich eine liste mit daten zu jeweiligen autos mit baujahr und gelaufenen kilometern habe, wie kann ich dann den preis in der matrix suchen lassen?, sodass auch wenn weniger als eine angebene kilometerzahl gelaufen ist er das zu dem nächsten schritt in der tabelle rundet?

Hajo_Zi
06.04.2012, 16:16
Matrix (http://hajo-excel.de/chCounter3/getfile.php?id=135)

<img src="http://Hajo-Excel.de/images/grusz1.gif" align="middle" height="40" alt="Grußformel"><a href="http://Hajo-Excel.de/index.htm" onclick="window.open(this.href);return false"><img border="0" src="http://Hajo-Excel.de/images/logo_hajo3.gif" align="middle" height="40" alt="Homepage"></a>

overmas
06.04.2012, 16:33
danke erstmal, hat schonmal geholfen

ein problem bleibt noch, da die gelaufene km zahl der autos aufsteigend sind immer bis 20.000km z.b., d.h. der erste schritt ist z.b. bis 20.000 km, wenn ein auto jetzt ein auto 13.000 gelaufen ist, funktioniert das mit 1 und 0 bei vergleich nicht und bei -1 nimmt der dann die höchste km zahl, da ich aufsteigend sortiert habe, gibt es da eine möglochkeit das zu umgehen?

Hajo_Zi
06.04.2012, 16:36
ich baue keine Datei nach. Die Zeit hat schon jemand investiert.

<a href="http://Hajo-Excel.de/index.htm" target="_blank" title="Hajo's Excelseiten">Gruß Hajo</a>

josef e
06.04.2012, 17:22
<div style="width:98%; margin-left:5px; margin-right:15px; text-align:justify;">
Hallo ?,

so?

<b>Tabelle1</b><br /><br /><table border="1" cellspacing="0" cellpadding="0" style="font-family:Tahoma,Arial; font-size:10pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:115px;" /><col style="width:85px;" /><col style="width:40px;" /><col style="width:40px;" /><col style="width:40px;" /><col style="width:40px;" /><col style="width:40px;" /><col style="width:40px;" /><col style="width:40px;" /><col style="width:40px;" /><col style="width:40px;" /><col style="width:40px;" /><col style="width:42px;" /><col style="width:80px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td >&nbsp;</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><td >L</td><td >M</td><td >N</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td style="font-weight:bold; text-align:center; ">KM bis / Baujahr</td><td style="font-weight:bold; text-align:right; ">2000</td><td style="font-weight:bold; text-align:right; ">2001</td><td style="font-weight:bold; text-align:right; ">2002</td><td style="font-weight:bold; text-align:right; ">2003</td><td style="font-weight:bold; text-align:right; ">2004</td><td style="font-weight:bold; text-align:right; ">2005</td><td style="font-weight:bold; text-align:right; ">2006</td><td style="font-weight:bold; text-align:right; ">2007</td><td style="font-weight:bold; text-align:right; ">2008</td><td style="font-weight:bold; text-align:right; ">2009</td><td style="font-weight:bold; text-align:right; ">2010</td><td style="font-weight:bold; text-align:right; ">2011</td><td >&nbsp;</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td style="font-weight:bold; text-align:right; ">20.000</td><td style="text-align:center; ">400</td><td style="text-align:center; ">600</td><td style="text-align:center; ">800</td><td style="text-align:center; ">1000</td><td style="text-align:center; ">1200</td><td style="text-align:center; ">1400</td><td style="text-align:center; ">1600</td><td style="text-align:center; ">1800</td><td style="text-align:center; ">2000</td><td style="text-align:center; ">2200</td><td style="text-align:center; ">2400</td><td style="text-align:center; ">2600</td><td >&nbsp;</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td style="font-weight:bold; text-align:right; ">40.000</td><td style="text-align:center; ">600</td><td style="text-align:center; ">900</td><td style="text-align:center; ">1200</td><td style="text-align:center; ">1500</td><td style="text-align:center; ">1800</td><td style="text-align:center; ">2100</td><td style="text-align:center; ">2400</td><td style="text-align:center; ">2700</td><td style="text-align:center; ">3000</td><td style="text-align:center; ">3300</td><td style="text-align:center; ">3600</td><td style="text-align:center; ">3900</td><td >&nbsp;</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td style="font-weight:bold; text-align:right; ">60.000</td><td style="text-align:center; ">800</td><td style="text-align:center; ">1200</td><td style="text-align:center; ">1600</td><td style="text-align:center; ">2000</td><td style="text-align:center; ">2400</td><td style="background-color:#ffff00; text-align:center; ">2800</td><td style="text-align:center; ">3200</td><td style="text-align:center; ">3600</td><td style="text-align:center; ">4000</td><td style="text-align:center; ">4400</td><td style="text-align:center; ">4800</td><td style="text-align:center; ">5200</td><td >&nbsp;</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td style="font-weight:bold; text-align:right; ">80.000</td><td style="text-align:center; ">1000</td><td style="text-align:center; ">1500</td><td style="text-align:center; ">2000</td><td style="text-align:center; ">2500</td><td style="text-align:center; ">3000</td><td style="text-align:center; ">3500</td><td style="text-align:center; ">4000</td><td style="text-align:center; ">4500</td><td style="text-align:center; ">5000</td><td style="text-align:center; ">5500</td><td style="text-align:center; ">6000</td><td style="text-align:center; ">6500</td><td >&nbsp;</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td style="font-weight:bold; text-align:right; ">100.000</td><td style="text-align:center; ">1200</td><td style="text-align:center; ">1800</td><td style="text-align:center; ">2400</td><td style="text-align:center; ">3000</td><td style="text-align:center; ">3600</td><td style="text-align:center; ">4200</td><td style="text-align:center; ">4800</td><td style="text-align:center; ">5400</td><td style="text-align:center; ">6000</td><td style="text-align:center; ">6600</td><td style="text-align:center; ">7200</td><td style="text-align:center; ">7800</td><td >&nbsp;</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >7</td><td style="font-weight:bold; text-align:right; ">120.000</td><td style="text-align:center; ">1400</td><td style="text-align:center; ">2100</td><td style="text-align:center; ">2800</td><td style="text-align:center; ">3500</td><td style="text-align:center; ">4200</td><td style="text-align:center; ">4900</td><td style="text-align:center; ">5600</td><td style="text-align:center; ">6300</td><td style="text-align:center; ">7000</td><td style="text-align:center; ">7700</td><td style="text-align:center; ">8400</td><td style="text-align:center; ">9100</td><td >&nbsp;</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >8</td><td style="font-weight:bold; text-align:right; ">140.000</td><td style="text-align:center; ">1600</td><td style="text-align:center; ">2400</td><td style="text-align:center; ">3200</td><td style="text-align:center; ">4000</td><td style="text-align:center; ">4800</td><td style="text-align:center; ">5600</td><td style="text-align:center; ">6400</td><td style="text-align:center; ">7200</td><td style="text-align:center; ">8000</td><td style="text-align:center; ">8800</td><td style="text-align:center; ">9600</td><td style="text-align:center; ">10400</td><td >&nbsp;</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >9</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >10</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >11</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >12</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >13</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >14</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >15</td><td style="text-align:right; ">Baujahr:</td><td style="text-align:center; ">2005</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >16</td><td style="text-align:right; ">Kilometerstand:</td><td style="text-align:center; "> &nbsp; &nbsp; &nbsp; 57.428 &nbsp; </td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >17</td><td style="text-align:right; ">Preis:</td><td style="background-color:#ffff00; text-align:center; ">2800</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >18</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</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>Formeln der Tabelle</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 >Zelle</td><td >Formel</td></tr><tr><td >B17</td><td >{=INDEX(B2:M8;MIN<span style=' color:008000; '>(WENN<span style=' color:#0000ff; '>(A2:A8&gt;=B16;ZEILE<span style=' color:#ff0000; '>(1:7)</span>)</span>)</span>;VERGLEICH<span style=' color:008000; '>(B15;B1:M1;0)</span>)}</td></tr></table></td></tr><tr><td ><span style=' font-family:Arial,Arial; font-size:9pt; font-weight:bold;'>Enth&auml;lt Matrixformel:</span><span style=' font-family:Arial,Arial; font-size:9pt;'><br />Umrandende </span><span style=' font-family:Arial,Arial; font-size:9pt; font-weight:bold;'>{ }</span><span style=' font-family:Arial,Arial; font-size:9pt;'> nicht miteingeben,<br />sondern Formel mit STRG+SHIFT+RETURN abschlie&szlig;en!</span></td></tr><tr><td ><a href="http://www.online-excel.de/excel/singsel.php?f=26" style="font-family:Arial; font-size:8pt;font-weight:bold;color:#000080;" target='_blank'>Matrix verstehen</a></td></tr></table> <br /><br /><span style="font-family:Arial; font-size:9pt; font-weight:bold;background-color:#ffffff; color:#000000; ">Excel Tabellen im Web darstellen &gt;&gt; </span><a style ="font-family:Arial; font-size:9pt; color:#fcf507; background-color:#800040; font-weight:bold;" href="http://www.excel-jeanie-html.de" target="_blank"> Excel Jeanie HTML 4 </a>




</div>

<div style="width:100px; text-align:center; color:white; font-style:italic; font-size:0.8em; font-family:Tahoma; background-color:royalblue;margin-left:5px; margin-top:15px; padding:4px; border:3px double darkblue;">&laquo; Gru&szlig; Sepp &raquo;</div>

overmas
06.04.2012, 18:27
genau, nur, dass mein kilometerstand in diesem fall 17.000 wäre, er aber dann nicht auf die 20.000 geht..., muss ich dann ne 0 km in die tabelle einfügen?

josef e
06.04.2012, 18:52
<div style="width:98%; margin-left:5px; margin-right:15px; text-align:justify;">
Hallo Kann dein Problem nicht nachvollziehen.

<b>Tabelle1</b><br /><br /><table border="1" cellspacing="0" cellpadding="0" style="font-family:Tahoma,Arial; font-size:10pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:115px;" /><col style="width:85px;" /><col style="width:40px;" /><col style="width:40px;" /><col style="width:40px;" /><col style="width:40px;" /><col style="width:40px;" /><col style="width:40px;" /><col style="width:40px;" /><col style="width:40px;" /><col style="width:40px;" /><col style="width:40px;" /><col style="width:42px;" /><col style="width:80px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td >&nbsp;</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><td >L</td><td >M</td><td >N</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td style="font-weight:bold; text-align:center; ">KM bis / Baujahr</td><td style="font-weight:bold; text-align:right; ">2000</td><td style="font-weight:bold; text-align:right; ">2001</td><td style="font-weight:bold; text-align:right; ">2002</td><td style="font-weight:bold; text-align:right; ">2003</td><td style="font-weight:bold; text-align:right; ">2004</td><td style="font-weight:bold; text-align:right; ">2005</td><td style="font-weight:bold; text-align:right; ">2006</td><td style="font-weight:bold; text-align:right; ">2007</td><td style="font-weight:bold; text-align:right; ">2008</td><td style="font-weight:bold; text-align:right; ">2009</td><td style="font-weight:bold; text-align:right; ">2010</td><td style="font-weight:bold; text-align:right; ">2011</td><td >&nbsp;</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td style="font-weight:bold; text-align:right; ">20.000</td><td style="text-align:center; ">400</td><td style="text-align:center; ">600</td><td style="text-align:center; ">800</td><td style="text-align:center; ">1000</td><td style="text-align:center; ">1200</td><td style="background-color:#ffff00; text-align:center; ">1400</td><td style="text-align:center; ">1600</td><td style="text-align:center; ">1800</td><td style="text-align:center; ">2000</td><td style="text-align:center; ">2200</td><td style="text-align:center; ">2400</td><td style="text-align:center; ">2600</td><td >&nbsp;</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td style="font-weight:bold; text-align:right; ">40.000</td><td style="text-align:center; ">600</td><td style="text-align:center; ">900</td><td style="text-align:center; ">1200</td><td style="text-align:center; ">1500</td><td style="text-align:center; ">1800</td><td style="text-align:center; ">2100</td><td style="text-align:center; ">2400</td><td style="text-align:center; ">2700</td><td style="text-align:center; ">3000</td><td style="text-align:center; ">3300</td><td style="text-align:center; ">3600</td><td style="text-align:center; ">3900</td><td >&nbsp;</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td style="font-weight:bold; text-align:right; ">60.000</td><td style="text-align:center; ">800</td><td style="text-align:center; ">1200</td><td style="text-align:center; ">1600</td><td style="text-align:center; ">2000</td><td style="text-align:center; ">2400</td><td style="text-align:center; ">2800</td><td style="text-align:center; ">3200</td><td style="text-align:center; ">3600</td><td style="text-align:center; ">4000</td><td style="text-align:center; ">4400</td><td style="text-align:center; ">4800</td><td style="text-align:center; ">5200</td><td >&nbsp;</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td style="font-weight:bold; text-align:right; ">80.000</td><td style="text-align:center; ">1000</td><td style="text-align:center; ">1500</td><td style="text-align:center; ">2000</td><td style="text-align:center; ">2500</td><td style="text-align:center; ">3000</td><td style="text-align:center; ">3500</td><td style="text-align:center; ">4000</td><td style="text-align:center; ">4500</td><td style="text-align:center; ">5000</td><td style="text-align:center; ">5500</td><td style="text-align:center; ">6000</td><td style="text-align:center; ">6500</td><td >&nbsp;</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td style="font-weight:bold; text-align:right; ">100.000</td><td style="text-align:center; ">1200</td><td style="text-align:center; ">1800</td><td style="text-align:center; ">2400</td><td style="text-align:center; ">3000</td><td style="text-align:center; ">3600</td><td style="text-align:center; ">4200</td><td style="text-align:center; ">4800</td><td style="text-align:center; ">5400</td><td style="text-align:center; ">6000</td><td style="text-align:center; ">6600</td><td style="text-align:center; ">7200</td><td style="text-align:center; ">7800</td><td >&nbsp;</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >7</td><td style="font-weight:bold; text-align:right; ">120.000</td><td style="text-align:center; ">1400</td><td style="text-align:center; ">2100</td><td style="text-align:center; ">2800</td><td style="text-align:center; ">3500</td><td style="text-align:center; ">4200</td><td style="text-align:center; ">4900</td><td style="text-align:center; ">5600</td><td style="text-align:center; ">6300</td><td style="text-align:center; ">7000</td><td style="text-align:center; ">7700</td><td style="text-align:center; ">8400</td><td style="text-align:center; ">9100</td><td >&nbsp;</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >8</td><td style="font-weight:bold; text-align:right; ">140.000</td><td style="text-align:center; ">1600</td><td style="text-align:center; ">2400</td><td style="text-align:center; ">3200</td><td style="text-align:center; ">4000</td><td style="text-align:center; ">4800</td><td style="text-align:center; ">5600</td><td style="text-align:center; ">6400</td><td style="text-align:center; ">7200</td><td style="text-align:center; ">8000</td><td style="text-align:center; ">8800</td><td style="text-align:center; ">9600</td><td style="text-align:center; ">10400</td><td >&nbsp;</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >9</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >10</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >11</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >12</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >13</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >14</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >15</td><td style="text-align:right; ">Baujahr:</td><td style="text-align:center; ">2005</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >16</td><td style="text-align:right; ">Kilometerstand:</td><td style="text-align:center; "> &nbsp; &nbsp; &nbsp; 17.000 &nbsp; </td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >17</td><td style="text-align:right; ">Preis:</td><td style="background-color:#ffff00; text-align:center; ">1400</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</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>Formeln der Tabelle</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 >Zelle</td><td >Formel</td></tr><tr><td >B17</td><td >{=INDEX(B2:M8;MIN<span style=' color:008000; '>(WENN<span style=' color:#0000ff; '>(A2:A8&gt;=B16;ZEILE<span style=' color:#ff0000; '>(1:7)</span>)</span>)</span>;VERGLEICH<span style=' color:008000; '>(B15;B1:M1;0)</span>)}</td></tr></table></td></tr><tr><td ><span style=' font-family:Arial,Arial; font-size:9pt; font-weight:bold;'>Enth&auml;lt Matrixformel:</span><span style=' font-family:Arial,Arial; font-size:9pt;'><br />Umrandende </span><span style=' font-family:Arial,Arial; font-size:9pt; font-weight:bold;'>{ }</span><span style=' font-family:Arial,Arial; font-size:9pt;'> nicht miteingeben,<br />sondern Formel mit STRG+SHIFT+RETURN abschlie&szlig;en!</span></td></tr><tr><td ><a href="http://www.online-excel.de/excel/singsel.php?f=26" style="font-family:Arial; font-size:8pt;font-weight:bold;color:#000080;" target='_blank'>Matrix verstehen</a></td></tr></table> <br /><br /><span style="font-family:Arial; font-size:9pt; font-weight:bold;background-color:#ffffff; color:#000000; ">Excel Tabellen im Web darstellen &gt;&gt; </span><a style ="font-family:Arial; font-size:9pt; color:#fcf507; background-color:#800040; font-weight:bold;" href="http://www.excel-jeanie-html.de" target="_blank"> Excel Jeanie HTML 4 </a>


</div>

<div style="width:100px; text-align:center; color:white; font-style:italic; font-size:0.8em; font-family:Tahoma; background-color:royalblue;margin-left:5px; margin-top:15px; padding:4px; border:3px double darkblue;">&laquo; Gru&szlig; Sepp &raquo;</div>