PDA

Vollständige Version anzeigen : Zeilen in andere Tabelle kopieren, wenn Bedingung erfüllt


olerostock
10.07.2014, 08:02
Hallo an alle,

ich komme mit dem kopieren von Zeilen in eine andere Tabelle nicht hin. Problem ist, dass in der Tabelle(Räume) keine Zahlen sondern nur Bezeichnungen stehen. Es sollen aus Tabelle(Räume) (Spalte A=Raumnummer, Spalte B=Raumname und Spalte C= Verwendung) nur die Raumnamen und Raumnummern in die Tabelle Verwendung kopiert werden, bei denen die Verwendung=Lager ist. In der Tabelle Verwendung sind Spalte A= Raumnummer und Spalte B= Raumname.
Datei "Tabelle kopieren" liegt bei.
Danke für Eure Hilfe!

Gruß Olerostock

Beverly
10.07.2014, 09:38
Hi,

ich nehme an, du meinst das so:

<br/><b><em>Räume</em></b><table border="1" cellspacing="0" cellpadding="0" style="border-color:#000000; border-width: 1px; font-size:11pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "><colgroup><col style="font-weight:bold; width:40px;" /><col style="width:116px;" /><col style="width:204px;" /><col style="width:104px;" /></colgroup><tr style="background-color:#99CCFF; text-align:center; font-weight:bold; "><td>&nbsp;</td><td>A</td><td>B</td><td>C</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">1</td><td style="border-color:#000000; color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:left; ">Raumnummer</td><td style="border-color:#000000; color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:left; ">Raumname</td><td style="border-color:#000000; color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:left; ">Verwendung</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">2</td><td style=" color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:center; ">BU.F01</td><td style=" color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:left; ">Logistikhof</td><td style=" color:#000000; border-color:#000000; background-color:#E26B0A ;; text-align:center; ">Nutzung gewerbliche &amp; industrielle Hallen - mittelschwere Arbeit</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">3</td><td style=" color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:center; ">BU.Parken</td><td style=" color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:left; ">Parken</td><td style=" color:#000000; border-color:#000000; background-color:#E26B0A ;; text-align:center; ">nicht konditionierte Zone</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">4</td><td style=" color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:center; ">BU.S05B</td><td style=" color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:left; ">TGA</td><td style=" color:#000000; border-color:#000000; background-color:#E26B0A ;; text-align:center; ">Technik unbeheizt</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">5</td><td style=" color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:center; ">BU.S05B</td><td style=" color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:left; ">ELT</td><td style=" color:#000000; border-color:#000000; background-color:#E26B0A ;; text-align:center; ">Technik unbeheizt</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">6</td><td style=" color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:center; ">BU.T01</td><td style=" color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:left; ">Treppenhaus</td><td style=" color:#000000; border-color:#000000; background-color:#E26B0A ;; text-align:center; ">Technik unbeheizt</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">7</td><td style=" color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:center; ">BU.T02</td><td style=" color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:left; ">Treppenhaus</td><td style=" color:#000000; border-color:#000000; background-color:#E26B0A ;; text-align:center; ">Technik unbeheizt</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">8</td><td style=" color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:center; ">BU.T03</td><td style=" color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:left; ">Treppenhaus</td><td style=" color:#000000; border-color:#000000; background-color:#E26B0A ;; text-align:center; ">Technik unbeheizt</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">9</td><td style=" color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:center; ">BU.A02</td><td style=" color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:left; ">Aufzug</td><td style=" color:#000000; border-color:#000000; background-color:#E26B0A ;; text-align:center; ">Verkehrsfläche</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">10</td><td style=" color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:center; ">BU.B01</td><td style=" color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:left; ">Müllentsorgung</td><td style=" color:#000000; border-color:#000000; background-color:#E26B0A ;; text-align:center; ">Technik unbeheizt</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">11</td><td style=" color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:center; ">BU.B02</td><td style=" color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:left; ">NS-Raum</td><td style=" color:#000000; border-color:#000000; background-color:#E26B0A ;; text-align:center; ">Lager</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">12</td><td style=" color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:center; ">BU.04A</td><td style=" color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:left; ">Vorraum</td><td style=" color:#000000; border-color:#000000; background-color:#E26B0A ;; text-align:center; ">WC und Sanitärräume in NWG</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">13</td><td style=" color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:center; ">BU.B03</td><td style=" color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:left; ">HA-Raum</td><td style=" color:#000000; border-color:#000000; background-color:#E26B0A ;; text-align:center; ">Technik unbeheizt</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">14</td><td style=" color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:center; ">BU.01A</td><td style=" color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:left; ">Fermenter</td><td style=" color:#000000; border-color:#000000; background-color:#E26B0A ;; text-align:center; ">Technik beheizt</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">15</td><td style=" color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:center; ">BU.01B</td><td style=" color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:left; ">Lager Chemie</td><td style=" color:#000000; border-color:#000000; background-color:#E26B0A ;; text-align:center; ">Lager</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">16</td><td style=" color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:center; ">BU.01C</td><td style=" color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:left; ">Schleuse</td><td style=" color:#000000; border-color:#000000; background-color:#E26B0A ;; text-align:center; ">Nutzung gewerbliche &amp; industrielle Hallen - mittelschwere Arbeit</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">17</td><td style=" color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:center; ">BU.01F</td><td style=" color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:left; ">Umkleide</td><td style=" color:#000000; border-color:#000000; background-color:#E26B0A ;; text-align:center; ">WC und Sanitärräume in NWG</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">18</td><td style=" color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:center; ">BU.01.F</td><td style=" color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:left; ">Kittank</td><td style=" color:#000000; border-color:#000000; background-color:#E26B0A ;; text-align:center; ">Technik unbeheizt</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">19</td><td style=" color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:center; ">BU.01E</td><td style=" color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:left; ">Lager Fermenter</td><td style=" color:#000000; border-color:#000000; background-color:#E26B0A ;; text-align:center; ">Lager</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">20</td><td style=" color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:center; ">BU.01D</td><td style=" color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:left; ">Labor Fermenter</td><td style=" color:#000000; border-color:#000000; background-color:#E26B0A ;; text-align:center; ">Technik beheizt</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">21</td><td style=" color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:center; ">BU.02A</td><td style=" color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:left; ">Produktionshalle</td><td style=" color:#000000; border-color:#000000; background-color:#E26B0A ;; text-align:center; ">Nutzung gewerbliche &amp; industrielle Hallen - mittelschwere Arbeit</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">22</td><td style=" color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:center; ">BU.04C</td><td style=" color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:left; ">WC D</td><td style=" color:#000000; border-color:#000000; background-color:#E26B0A ;; text-align:center; ">WC und Sanitärräume in NWG</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">23</td><td style=" color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:center; ">BU.04B</td><td style=" color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:left; ">WC H</td><td style=" color:#000000; border-color:#000000; background-color:#E26B0A ;; text-align:center; ">WC und Sanitärräume in NWG</td></tr></table><br/><br/><b><em>Verwendung</em></b><table border="1" cellspacing="0" cellpadding="0" style="border-color:#000000; border-width: 1px; font-size:11pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "><colgroup><col style="font-weight:bold; width:40px;" /><col style="width:123px;" /><col style="width:97px;" /></colgroup><tr style="background-color:#99CCFF; text-align:center; font-weight:bold; "><td>&nbsp;</td><td>A</td><td>B</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">1</td><td style="border-color:#000000; color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:left; ">Raumnummer</td><td style="border-color:#000000; color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:left; ">Raumname</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">2</td><td style="border-color:#000000; color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:left; ">BU.B02</td><td style="border-color:#000000; color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:left; ">NS-Raum</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">3</td><td style="border-color:#000000; color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:left; ">BU.01B</td><td style="border-color:#000000; color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:left; ">Lager Chemie</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">4</td><td style="border-color:#000000; color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:left; ">BU.01E</td><td style="border-color:#000000; color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:left; ">Lager Fermenter</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">5</td><td style="border-color:#000000; color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:left; ">&nbsp;</td><td style="border-color:#000000; color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:left; ">&nbsp;</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">6</td><td style="border-color:#000000; color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:left; ">&nbsp;</td><td style="border-color:#000000; color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:left; ">&nbsp;</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">7</td><td style="border-color:#000000; color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:left; ">&nbsp;</td><td style="border-color:#000000; color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:left; ">&nbsp;</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">8</td><td style="border-color:#000000; color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:left; ">&nbsp;</td><td style="border-color:#000000; color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:left; ">&nbsp;</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">9</td><td style="border-color:#000000; color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:left; ">&nbsp;</td><td style="border-color:#000000; color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:left; ">&nbsp;</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">10</td><td style="border-color:#000000; color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:left; ">&nbsp;</td><td style="border-color:#000000; color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:left; ">&nbsp;</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">11</td><td style="border-color:#000000; color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:left; ">&nbsp;</td><td style="border-color:#000000; color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:left; ">&nbsp;</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">12</td><td style="border-color:#000000; color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:left; ">&nbsp;</td><td style="border-color:#000000; color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:left; ">&nbsp;</td></tr></table><br/><table border="1" cellspacing="0" cellpadding="0" style="border-color:#000000; border-width: 1px;font-size:11pt; background-color:#ffffff; width:800px;padding-left:2pt; padding-right:2pt; "><tr style="background-color:#FFCC66; text-align:center; font-weight:bold; "><td colspan="3" > verwendete Formeln </td><td> </td></tr><tr valign="top" style="background-color:#FFCC66; text-align:center; font-weight:bold; "><td> Zelle </td><td> Formel</td><td> Bereich </td> <td>N/A</td></tr><tr><td>A2:A12</td><td>{=WENNFEHLER(WENN(ZEILE(Z1)&gt;(Räume!C$1:C$99="Lager");"";INDEX(Räume!A:A;KKLEINSTE(WENN((Räume!C$1:C$99="Lager");ZEILE($1:$99));ZEILE(Z1))));"")}</td><td>$A$2</td><td>&nbsp;</td></tr><tr><td>B2:B12</td><td>{=WENNFEHLER(WENN(ZEILE(Z1)&gt;(Räume!C$1:C$99="Lager");"";INDEX(Räume!B:B;KKLEINSTE(WENN((Räume!C$1:C$99="Lager");ZEILE($1:$99));ZEILE(Z1))));"")}</td><td>$B$2</td><td>&nbsp;</td></tr></table><b>{} Matrixformel mit Strg+Umschalt+Enter abschließen<br/>Matrixformeln sind durch geschweifte Klammern {} eingeschlossen<br/>Diese Klammern nicht eingeben!!</b><br/><table cellspacing="0" cellpadding="0"><tr style="text-align:left; font-weight:bold; " class="style21"><td style="text-align:left; font-size: xx-small" ><a href="http://excel-inn.de/dateien/vba_beispiele/tabellenanzeige_in_html_addin.zip" >Excel-Inn.de</a></td></tr> <tr style="text-align:left; font-weight:bold; " class="style21"><td style="text-align:left; font-size: xx-small" ><a href='http://Hajo-Excel.de/tools.htm' >Hajo-Excel.de</a></td></tr><tr style="text-align:left; font-weight:bold;" ><td style="text-align:left; font-size: xx-small" >XHTML-Tabelle zur Darstellung in Foren, einschl. der neuen Funktionen ab Version 2007</td></tr><tr style="text-align:left; font-weight:bold; " ><td style="text-align:left; font-size: xx-small" > Add-In-Version 18.08 einschl. 64 Bit</td></tr></table><br/>

Formelursprung siehe hier: http://www.excelformeln.de/formeln.html?welcher=30

<hr width="20%" align="left"><img src="http://excel-inn.de/images/grusz.gif" height=35" align="left" alt="Grußformel"><a href="http://excel-inn.de/"><img border="0" src="http://excel-inn.de/images/logo1.gif" height=35" align="middle" alt="Beverly's Excel - Inn"></a>

olerostock
10.07.2014, 10:16
Hallo Beverly,

Danke für Deine Hilfe. Ich habe da noch ein Problem. Wenn in der Tabelle Räume die Raumnummer nicht in Spalte "A" sondern Spalte "C" ist und der Raumname in Spalte "D" und nicht in "B" ist, sowie die ersten Werte in der Tabelle Räume in der Zeile 17 stehen? wie verhält es sich dann mit der Zuordnung bei "Z"?
Kannst Du mir da noch mal auf die Sprünge helfen?

Danke
Gruß Olerostock

Beverly
10.07.2014, 10:30
Hi,

und weshalb kann man nicht gleich die Mappe so hochladen wie die Originalbedingunggen sind?!

<br/><b><em>Verwendung</em></b><table border="1" cellspacing="0" cellpadding="0" style="border-color:#000000; border-width: 1px; font-size:11pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "><colgroup><col style="font-weight:bold; width:40px;" /><col style="width:123px;" /><col style="width:97px;" /></colgroup><tr style="background-color:#99CCFF; text-align:center; font-weight:bold; "><td>&nbsp;</td><td>A</td><td>B</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">1</td><td style="border-color:#000000; color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:left; ">Raumnummer</td><td style="border-color:#000000; color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:left; ">Raumname</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">2</td><td style="border-color:#000000; color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:left; ">BU.B02</td><td style="border-color:#000000; color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:left; ">NS-Raum</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">3</td><td style="border-color:#000000; color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:left; ">BU.01B</td><td style="border-color:#000000; color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:left; ">Lager Chemie</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">4</td><td style="border-color:#000000; color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:left; ">BU.01E</td><td style="border-color:#000000; color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:left; ">Lager Fermenter</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">5</td><td style="border-color:#000000; color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:left; ">&nbsp;</td><td style="border-color:#000000; color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:left; ">&nbsp;</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">6</td><td style="border-color:#000000; color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:left; ">&nbsp;</td><td style="border-color:#000000; color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:left; ">&nbsp;</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">7</td><td style="border-color:#000000; color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:left; ">&nbsp;</td><td style="border-color:#000000; color:#000000; border-color:#000000; background-color:#FFFFFF ;; text-align:left; ">&nbsp;</td></tr></table><br/><table border="1" cellspacing="0" cellpadding="0" style="border-color:#000000; border-width: 1px;font-size:11pt; background-color:#ffffff; width:800px;padding-left:2pt; padding-right:2pt; "><tr style="background-color:#FFCC66; text-align:center; font-weight:bold; "><td colspan="3" > verwendete Formeln </td><td> </td></tr><tr valign="top" style="background-color:#FFCC66; text-align:center; font-weight:bold; "><td> Zelle </td><td> Formel</td><td> Bereich </td> <td>N/A</td></tr><tr><td>A2:A7</td><td>{=WENNFEHLER(WENN(ZEILE(Z1)&gt;(Räume!E$1:E$99="Lager");"";INDEX(Räume!C:C;KKLEINSTE(WENN((Räume!E$1:E$99="Lager");ZEILE($1:$99));ZEILE(Z1))));"")}</td><td>$A$2</td><td>&nbsp;</td></tr><tr><td>B2:B7</td><td>{=WENNFEHLER(WENN(ZEILE(Z1)&gt;(Räume!E$1:E$99="Lager");"";INDEX(Räume!D:&nbsp;D;KKLEINSTE(WENN((Räume!E$1:E$99="Lager");ZEILE($1:$99));ZEILE(Z1))));"")}</td><td>$B$2</td><td>&nbsp;</td></tr></table><b>{} Matrixformel mit Strg+Umschalt+Enter abschließen<br/>Matrixformeln sind durch geschweifte Klammern {} eingeschlossen<br/>Diese Klammern nicht eingeben!!</b><br/><table cellspacing="0" cellpadding="0"><tr style="text-align:left; font-weight:bold; " class="style21"><td style="text-align:left; font-size: xx-small" ><a href="http://excel-inn.de/dateien/vba_beispiele/tabellenanzeige_in_html_addin.zip" >Excel-Inn.de</a></td></tr> <tr style="text-align:left; font-weight:bold; " class="style21"><td style="text-align:left; font-size: xx-small" ><a href='http://Hajo-Excel.de/tools.htm' >Hajo-Excel.de</a></td></tr><tr style="text-align:left; font-weight:bold;" ><td style="text-align:left; font-size: xx-small" >XHTML-Tabelle zur Darstellung in Foren, einschl. der neuen Funktionen ab Version 2007</td></tr><tr style="text-align:left; font-weight:bold; " ><td style="text-align:left; font-size: xx-small" > Add-In-Version 18.08 einschl. 64 Bit</td></tr></table><br/>

<hr width="20%" align="left"><img src="http://excel-inn.de/images/grusz.gif" height=35" align="left" alt="Grußformel"><a href="http://excel-inn.de/"><img border="0" src="http://excel-inn.de/images/logo1.gif" height=35" align="middle" alt="Beverly's Excel - Inn"></a>

olerostock
10.07.2014, 11:06
Hallo Beverly,

Danke für Deine Hilfe. Ich konnte die Datei nicht im Original hochladen, weil Sie viel zu groß ist. Beim erstellen eines Auszuges hatte ich die unterschiedliche Anordnung der Zeilen und Spalten nicht bedacht.

Ich Danke Dir noch mals ganz herzlich.

Beste Grüße
Olerostock