PDA

Vollständige Version anzeigen : Ergebnis aus 3 Suchkriterien


Guestt834a
01.07.2014, 14:53
Hallo Zusammen,

ich bin Neu in diesem Forum und brauche dringend Hilfe von Excel-Experten. Leider haben mir die Beiträge bzgl Index Vergleich in diesem Forum nicht weitergeholfen.

Ich habe eine Aufgabe bekommen, in der (vorerst) drei Suchkriterien erfüllt sein sollen und der Wert soll in ein 2. Tabellenblatt übertragen werden. Werte aus 2 Suchkriterien konnte ich mit Unterstützung ermitteln.

Die 1. Tabelle (=Tabelle1) ist die Originaltabelle, die direkt vom SAP ausgespuckt wird und somit nicht bearbeitet werden darf. Die Texte, Werte und Zahlen sind so vorgegeben. Manche Produkte, die in einer KW keine Umsätze habe, werden z.T. nicht aufgelistet, andere wiederum schon. Es können auch Produkte hinzukommen. Aber alle Produkte sollen in Tabelle2 aufgelistet sein, unabhängig davon ob Umsätze da sind oder nicht. In Tabelle1 soll nach den folgenden Suchkriterien ermittelt werden:

1. Mitarbeiter
2. Produkt
3. Kalenderwoche

(Zur Info: 23.2014 ist von SAP vorgegeben und ist eine verbundene Zelle. Das gleiche gilt eigentlich auch für KW 24 - bis 27)

Tabelle1 ist folgendermaßen aufgebaut:

<b>Tabelle1</b><br /><br /><table border="1" cellspacing="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:133px;" /><col style="width:80px;" /><col style="width:80px;" /><col style="width:80px;" /><col style="width:80px;" /><col style="width:80px;" /><col style="width:80px;" /><col style="width:80px;" /><col style="width:80px;" /><col style="width:80px;" /><col style="width:80px;" /><col style="width:80px;" /><col style="width:80px;" /><col style="width:80px;" /><col style="width:80px;" /><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><td >O</td><td >P</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; ">Kalenderjahr/Monat</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; text-align:right; ">Juni 2014</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; ">&nbsp;</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; ">&nbsp;</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; ">&nbsp;</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; ">&nbsp;</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; ">&nbsp;</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; ">&nbsp;</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; ">&nbsp;</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; ">&nbsp;</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; ">&nbsp;</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; ">&nbsp;</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; ">&nbsp;</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; ">&nbsp;</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; ">&nbsp;</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; ">&nbsp;</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; ">Kalenderjahr/Woche</td><td colspan="13" style="background-color:#eeeeee; font-weight:bold; font-size:9pt; text-align:left; ">23.2014</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; text-align:right; ">24.2014</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; ">&nbsp;</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; ">Profit-Center</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; text-align:right; ">1000</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; text-align:right; ">1001</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; text-align:right; ">1002</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; text-align:right; ">1003</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; text-align:right; ">1004</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; text-align:right; ">1005</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; text-align:right; ">1010</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; text-align:right; ">1011</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; text-align:right; ">1013</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; text-align:right; ">1014</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; text-align:right; ">1015</td><td style="background-color:#ffff00; font-weight:bold; font-size:9pt; text-align:right; ">1016</td><td style="background-color:#ffff00; font-weight:bold; font-size:9pt; text-align:right; ">1017</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; text-align:right; ">1000</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; text-align:right; ">1001</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; ">Profit-Center (Text)</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; ">Produkt A</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; ">Produkt B</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; ">Produkt C</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; ">Produkt D</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; ">Produkt E</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; ">Produkt F</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; ">Produkt G</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; ">Produkt H</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; ">Produkt I</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; ">Produkt J</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; ">Produkt K</td><td style="background-color:#ffff00; font-weight:bold; font-size:9pt; ">Produkt L</td><td style="background-color:#ffff00; font-weight:bold; font-size:9pt; ">Produkt M</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; ">Produkt A</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; ">Produkt B</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; ">Mitarbeiter</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; ">Umsatz</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; ">Umsatz</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; ">Umsatz</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; ">Umsatz</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; ">Umsatz</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; ">Umsatz</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; ">Umsatz</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; ">Umsatz</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; ">Umsatz</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; ">Umsatz</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; ">Umsatz</td><td style="background-color:#ffff00; font-weight:bold; font-size:9pt; ">Umsatz</td><td style="background-color:#ffff00; font-weight:bold; font-size:9pt; ">Umsatz</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; ">Umsatz</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; ">Umsatz</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >7</td><td style="background-color:#eeeeee; font-size:9pt; ">Niedermeyer</td><td style="background-color:#dfe0e3; font-size:9pt; text-align:right; ">2.220,59 EUR</td><td style="background-color:#dfe0e3; font-size:9pt; text-align:right; ">1.000,00 EUR</td><td style="background-color:#dfe0e3; font-size:9pt; text-align:right; ">50,00 EUR</td><td style="background-color:#dfe0e3; font-size:9pt; text-align:right; ">70</td><td style="background-color:#dfe0e3; font-size:9pt; ">&nbsp;</td><td style="background-color:#dfe0e3; font-size:9pt; text-align:right; ">58,50 EUR</td><td style="background-color:#dfe0e3; font-size:9pt; ">&nbsp;</td><td style="background-color:#dfe0e3; font-size:9pt; text-align:right; ">7.850,00 EUR</td><td style="background-color:#dfe0e3; font-size:9pt; ">&nbsp;</td><td style="background-color:#dfe0e3; font-size:9pt; text-align:right; ">500</td><td style="background-color:#dfe0e3; font-size:9pt; text-align:right; ">400</td><td style="background-color:#dfe0e3; font-size:9pt; ">&nbsp;</td><td style="background-color:#dfe0e3; font-size:9pt; ">&nbsp;</td><td style="background-color:#dfe0e3; font-size:9pt; text-align:right; ">28.000,00 EUR</td><td style="background-color:#dfe0e3; font-size:9pt; text-align:right; ">500,21 EUR</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >8</td><td style="background-color:#eeeeee; font-size:9pt; ">Berthold</td><td style="background-color:#dfe0e3; font-size:9pt; text-align:right; ">4.220,25 EUR</td><td style="background-color:#dfe0e3; font-size:9pt; text-align:right; ">1.000,00 EUR</td><td style="background-color:#dfe0e3; font-size:9pt; text-align:right; ">50,00 EUR</td><td style="background-color:#dfe0e3; font-size:9pt; ">&nbsp;</td><td style="background-color:#dfe0e3; font-size:9pt; ">&nbsp;</td><td style="background-color:#dfe0e3; font-size:9pt; ">&nbsp;</td><td style="background-color:#dfe0e3; font-size:9pt; ">&nbsp;</td><td style="background-color:#dfe0e3; font-size:9pt; ">&nbsp;</td><td style="background-color:#dfe0e3; font-size:9pt; ">&nbsp;</td><td style="background-color:#dfe0e3; font-size:9pt; ">&nbsp;</td><td style="background-color:#dfe0e3; font-size:9pt; ">&nbsp;</td><td style="background-color:#dfe0e3; font-size:9pt; ">&nbsp;</td><td style="background-color:#dfe0e3; font-size:9pt; ">&nbsp;</td><td style="background-color:#dfe0e3; font-size:9pt; text-align:right; ">2.300,00 EUR</td><td style="background-color:#dfe0e3; font-size:9pt; text-align:right; ">4.435,52 EUR</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >9</td><td style="background-color:#eeeeee; font-size:9pt; ">H</td><td style="background-color:#dfe0e3; font-size:9pt; ">&nbsp;</td><td style="background-color:#dfe0e3; font-size:9pt; ">&nbsp;</td><td style="background-color:#dfe0e3; font-size:9pt; ">&nbsp;</td><td style="background-color:#dfe0e3; font-size:9pt; ">&nbsp;</td><td style="background-color:#dfe0e3; font-size:9pt; ">&nbsp;</td><td style="background-color:#dfe0e3; font-size:9pt; ">&nbsp;</td><td style="background-color:#dfe0e3; font-size:9pt; ">&nbsp;</td><td style="background-color:#dfe0e3; font-size:9pt; ">&nbsp;</td><td style="background-color:#dfe0e3; font-size:9pt; ">&nbsp;</td><td style="background-color:#dfe0e3; font-size:9pt; ">&nbsp;</td><td style="background-color:#dfe0e3; font-size:9pt; ">&nbsp;</td><td style="background-color:#dfe0e3; font-size:9pt; ">&nbsp;</td><td style="background-color:#dfe0e3; font-size:9pt; ">&nbsp;</td><td style="background-color:#dfe0e3; font-size:9pt; ">&nbsp;</td><td style="background-color:#dfe0e3; font-size:9pt; ">&nbsp;</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >10</td><td style="background-color:#eeeeee; font-size:9pt; ">R</td><td style="background-color:#dfe0e3; font-size:9pt; ">&nbsp;</td><td style="background-color:#dfe0e3; font-size:9pt; ">&nbsp;</td><td style="background-color:#dfe0e3; font-size:9pt; ">&nbsp;</td><td style="background-color:#dfe0e3; font-size:9pt; ">&nbsp;</td><td style="background-color:#dfe0e3; font-size:9pt; ">&nbsp;</td><td style="background-color:#dfe0e3; font-size:9pt; ">&nbsp;</td><td style="background-color:#dfe0e3; font-size:9pt; ">&nbsp;</td><td style="background-color:#dfe0e3; font-size:9pt; ">&nbsp;</td><td style="background-color:#dfe0e3; font-size:9pt; ">&nbsp;</td><td style="background-color:#dfe0e3; font-size:9pt; ">&nbsp;</td><td style="background-color:#dfe0e3; font-size:9pt; ">&nbsp;</td><td style="background-color:#dfe0e3; font-size:9pt; ">&nbsp;</td><td style="background-color:#dfe0e3; font-size:9pt; ">&nbsp;</td><td style="background-color:#dfe0e3; font-size:9pt; ">&nbsp;</td><td style="background-color:#dfe0e3; font-size:9pt; ">&nbsp;</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.8 </a>

Tabelle2 sieht anders aus:
Diese Tabelle wird dagegen bearbeitet. Wenn ein Produkt in KW 23 keine Umsätze hat, soll da Null stehen. Es geht dann weiter bis zur Ende eines Monats. KW 24+ Mitarbeiter X+ Produkt X usw. Wenn ein neues Produkt in die Liste eingefügt wird, dass erst in KW 27 Umsätze hat, soll es trotzdem in KW 23-26 der Produktname stehen, aber durch diese gesuchte Formel ein Null herauskommen.

<b>Tabelle2</b><br /><br /><table border="1" cellspacing="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:80px;" /><col style="width:115px;" /><col style="width:80px;" /><col style="width:80px;" /><col style="width:80px;" /><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></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; ">Kalenderjahr/Monat</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; ">&nbsp;</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; text-align:right; ">Juni 2014</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; ">&nbsp;</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; ">&nbsp;</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; ">&nbsp;</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; ">Kalenderjahr/Woche</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; ">&nbsp;</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; text-align:right; ">23.2014</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; ">&nbsp;</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; text-align:right; ">24.2014</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; ">&nbsp;</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; ">Profit-Center</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; ">Profit-Center (Text)</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; ">Plan</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; ">Ist</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; ">Plan</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; ">Ist</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; ">Niedermeyer</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; ">&nbsp;</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; ">&nbsp;</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; ">&nbsp;</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; ">&nbsp;</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; ">&nbsp;</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; text-align:left; ">1000</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; ">Produkt A</td><td style="font-family:Arial; font-size:10pt; ">&nbsp;</td><td style="background-color:#dfe0e3; font-size:9pt; text-align:right; ">2.220,59 EUR</td><td style="font-size:10pt; ">&nbsp;</td><td style="font-family:Arial; font-size:9pt; ">&nbsp;</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; text-align:right; ">1001</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; ">Produkt B</td><td style="font-family:Arial; font-size:10pt; ">&nbsp;</td><td style="background-color:#dfe0e3; font-size:9pt; text-align:right; ">1.000,00 EUR</td><td style="font-size:10pt; ">&nbsp;</td><td >&nbsp;</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >7</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; text-align:right; ">1002</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; ">Produkt C</td><td style="font-family:Arial; font-size:10pt; ">&nbsp;</td><td >&nbsp;</td><td style="font-size:10pt; ">&nbsp;</td><td >&nbsp;</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >8</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; text-align:right; ">1003</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; ">Produkt D</td><td style="font-family:Arial; font-size:10pt; ">&nbsp;</td><td >&nbsp;</td><td style="font-size:10pt; ">&nbsp;</td><td >&nbsp;</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >9</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; text-align:right; ">1004</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; ">Produkt E</td><td style="font-family:Arial; font-size:10pt; ">&nbsp;</td><td >&nbsp;</td><td style="font-size:10pt; ">&nbsp;</td><td >&nbsp;</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >10</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; text-align:right; ">1005</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; ">Produkt F</td><td style="font-family:Arial; font-size:10pt; ">&nbsp;</td><td >&nbsp;</td><td style="font-size:10pt; ">&nbsp;</td><td >&nbsp;</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >11</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; text-align:right; ">1010</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; ">Produkt G</td><td style="font-family:Arial; font-size:10pt; ">&nbsp;</td><td >&nbsp;</td><td style="font-size:10pt; ">&nbsp;</td><td >&nbsp;</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >12</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; text-align:right; ">1011</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; ">Produkt H</td><td style="font-family:Arial; font-size:10pt; ">&nbsp;</td><td >&nbsp;</td><td style="font-size:10pt; ">&nbsp;</td><td >&nbsp;</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >13</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; text-align:right; ">1013</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; ">Produkt I</td><td style="font-family:Arial; font-size:10pt; ">&nbsp;</td><td >&nbsp;</td><td style="font-size:10pt; ">&nbsp;</td><td >&nbsp;</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >14</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; text-align:right; ">1014</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; ">Produkt J</td><td style="font-family:Arial; font-size:10pt; ">&nbsp;</td><td >&nbsp;</td><td style="font-size:10pt; ">&nbsp;</td><td >&nbsp;</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >15</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; text-align:right; ">1015</td><td style="background-color:#eeeeee; font-weight:bold; font-size:9pt; ">Produkt K</td><td style="font-family:Arial; font-size:10pt; ">&nbsp;</td><td >&nbsp;</td><td style="font-size:10pt; ">&nbsp;</td><td >&nbsp;</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >16</td><td style="background-color:#ffff00; font-weight:bold; font-size:9pt; text-align:right; ">1016</td><td style="background-color:#ffff00; font-weight:bold; font-size:9pt; ">Produkt L</td><td style="font-family:Arial; font-size:10pt; ">&nbsp;</td><td >&nbsp;</td><td style="font-size:10pt; ">&nbsp;</td><td >&nbsp;</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >17</td><td style="background-color:#ffff00; font-weight:bold; font-size:9pt; text-align:right; ">1017</td><td style="background-color:#ffff00; font-weight:bold; font-size:9pt; ">Produkt M</td><td style="font-family:Arial; font-size:10pt; ">&nbsp;</td><td >&nbsp;</td><td style="font-size:10pt; ">&nbsp;</td><td >&nbsp;</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >18</td><td style="background-color:#e2efda; ">&nbsp;</td><td style="background-color:#e2efda; font-weight:bold; font-size:9pt; ">Gesamt Niedermeyer</td><td style="background-color:#e2efda; font-weight:bold; ">&nbsp;</td><td style="background-color:#e2efda; font-weight:bold; ">&nbsp;</td><td style="background-color:#e2efda; font-weight:bold; ">&nbsp;</td><td style="background-color:#e2efda; font-weight:bold; ">&nbsp;</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.8


Weiss jemand Rat? Ich bin für jede Hilfe dankbar.