Lotto-Totostrategen
Hilfe bei Excel Tabelle - Druckversion

+- Lotto-Totostrategen (https://Lotto-Totostrategen.de)
+-- Forum: Small Talk (https://Lotto-Totostrategen.de/forumdisplay.php?fid=890)
+--- Forum: Diverses (https://Lotto-Totostrategen.de/forumdisplay.php?fid=887)
+--- Thema: Hilfe bei Excel Tabelle (/showthread.php?tid=23486)

Seiten: 1 2

Hallo Peter K. :wink: maximale Mehrfachnennung liegt bei 4 fach, und die Spaltenzahl liegt fest bei 15. Ich - Skipper - 26.03.2013

Hallo Peter K. Wink

maximale Mehrfachnennung liegt bei 4 fach, und die

Spaltenzahl liegt fest bei 15.


Ich kann Dir auch die Tabelle Übersenden, allerdings ist keine
Ms-Office Tabelle sonder eine LibreOffice Tabelle ???

[quote][i]Original von Skipper[/i] Hallo Peter K. :wink: maximale Mehrfachnennung liegt bei 4 fach, und die Spal - Peter K. - 26.03.2013

Zitat:Original von Skipper
Hallo Peter K. Wink

maximale Mehrfachnennung liegt bei 4 fach, und die

Spaltenzahl liegt fest bei 15.


Ich kann Dir auch die Tabelle Übersenden, allerdings ist keine
Ms-Office Tabelle sonder eine LibreOffice Tabelle ???


Hallo Skipper,

Ja, schick mal rüber, evt. kann ich sie ja mit Excel einlesen.

Vielleicht kannst Du sie ja auch als Textdatei mit Trennzeichen Semikolon (sog. CSV-Datei) aus Deinem Programm exportieren ?

Gruß Peter K.

.

Hallo Peter K. :wink: Du hast eine e-Mail mit Datei. 1000 Dank - Skipper - 26.03.2013

Hallo Peter K. Wink

Du hast eine e-Mail mit Datei.

1000 Dank

Hallo Skipper, hier mal der erste Schnellschuß mit einem Lösungsansatz : [IMG]http://i48.tinypic.com/zntz05. - Peter K. - 27.03.2013

Hallo Skipper,

hier mal der erste Schnellschuß mit einem Lösungsansatz :

[Bild: zntz05.jpg]

Die Formeln lauten :

In Zelle Q3 bis AE3
=WENN(SUMMENPRODUKT(ZÄHLENWENN($A3:$O3;A3))>1;A3;"")
=WENN(UND(SUMMENPRODUKT(ZÄHLENWENN($A3:$O3;B3))>1;SUMMENPRODUKT(ZÄHLENWENN($Q3:Q3;B3))=0);B3;"")
=WENN(UND(SUMMENPRODUKT(ZÄHLENWENN($A3:$O3;C3))>1;SUMMENPRODUKT(ZÄHLENWENN($Q3:R3;C3))=0);C3;"")
=WENN(UND(SUMMENPRODUKT(ZÄHLENWENN($A3:$O3;D3))>1;SUMMENPRODUKT(ZÄHLENWENN($Q3:S3;D3))=0);D3;"")
=WENN(UND(SUMMENPRODUKT(ZÄHLENWENN($A3:$O3;E3))>1;SUMMENPRODUKT(ZÄHLENWENN($Q3:T3;E3))=0);E3;"")
=WENN(UND(SUMMENPRODUKT(ZÄHLENWENN($A3:$O3;F3))>1;SUMMENPRODUKT(ZÄHLENWENN($Q3:U3;F3))=0);F3;"")
=WENN(UND(SUMMENPRODUKT(ZÄHLENWENN($A3:$O3;G3))>1;SUMMENPRODUKT(ZÄHLENWENN($Q3:V3;G3))=0);G3;"")
=WENN(UND(SUMMENPRODUKT(ZÄHLENWENN($A3:$O3;H3))>1;SUMMENPRODUKT(ZÄHLENWENN($Q3:W3;H3))=0);H3;"")
=WENN(UND(SUMMENPRODUKT(ZÄHLENWENN($A3:$O3;I3))>1;SUMMENPRODUKT(ZÄHLENWENN($Q3:X3;I3))=0);I3;"")
=WENN(UND(SUMMENPRODUKT(ZÄHLENWENN($A3:$O3;J3))>1;SUMMENPRODUKT(ZÄHLENWENN($Q3:Y3;J3))=0);J3;"")
=WENN(UND(SUMMENPRODUKT(ZÄHLENWENN($A3:$O3;K3))>1;SUMMENPRODUKT(ZÄHLENWENN($Q3:Z3;K3))=0);K3;"")
=WENN(UND(SUMMENPRODUKT(ZÄHLENWENN($A3:$O3;L3))>1;SUMMENPRODUKT(ZÄHLENWENN($Q3:AA3;L3))=0);L3;"")
=WENN(UND(SUMMENPRODUKT(ZÄHLENWENN($A3:$O3;M3))>1;SUMMENPRODUKT(ZÄHLENWENN($Q3:AB3;M3))=0);M3;"")
=WENN(UND(SUMMENPRODUKT(ZÄHLENWENN($A3:$O3;N3))>1;SUMMENPRODUKT(ZÄHLENWENN($Q3:AC3;N3))=0);N3;"")
=WENN(UND(SUMMENPRODUKT(ZÄHLENWENN($A3:$O3;O3))>1;SUMMENPRODUKT(ZÄHLENWENN($Q3:AD3;O3))=0);O3;"")

Wie Du siehst, habe ich eine UND-Verknüpfung gewählt.

Zu beachten ist, daß im zweiten Teil der UND-Verknüpfung der Bereich im Summenprodukt jeweils um eine Zelle erweitert wird.

Ich schicke Dir eine Tabelle im Excel 1997-2003 - Format,

ich hoffe Du kannst die dann in Dein Programm einlesen.

Wenn nicht, mußt Du halt tippen. :huegli:

Oder vom nächsten Lottogewinn mal 100 € für ein MS-Office opfern. :huegli:


Bitte das ganze nochmal "zu Fuß" mit Deiner bisherigen händischen Datei überprüfen.

Ich hoffe, keinen Gedankenfehler gemacht zu haben.


@Peter(Conquistador) dem Excelking : Bitte mal auf logische Fehler checken, Danke.


Beste Grüße

Peter K.

.

Hi Skipper, folgende Lösung: Die Tabelle mit den Formeln von Peter K. In Q2 Formel =WENN(SUMMENPRODUKT(ZÄHLENWE - Conquistador - 27.03.2013

Hi Skipper,

folgende Lösung:

Die Tabelle mit den Formeln von Peter K.

In Q2 Formel =WENN(SUMMENPRODUKT(ZÄHLENWENN(A$2:$O$2;A$2))>1;A$2;"")
In R2 Formel =WENN(SUMMENPRODUKT(ZÄHLENWENN(B$2:$O$2;B$2))>1;B$2;"")
In S2 Formel =WENN(SUMMENPRODUKT(ZÄHLENWENN(C$2:$O$2;C$2))>1;C$2;"")
In T2 Formel =WENN(SUMMENPRODUKT(ZÄHLENWENN(D$2:$O$2;D$2))>1;D$2;"")
In U2 Formel =WENN(SUMMENPRODUKT(ZÄHLENWENN(E$2:$O$2;E$2))>1;E$2;"")
In V2 Formel =WENN(SUMMENPRODUKT(ZÄHLENWENN(F$2:$O$2;F$2))>1;F$2;"")

erweitern:

Dazu die Spalten P-AE markieren -->Einfügen -->Spalten
die Formeln bleiben dann erhalten und stehen dann in AG-AU

In Q1-AE1 die Zahlen 1-15 eingeben

in Q2 Formel =WENN(SUMMENPRODUKT(ZÄHLENWENN(AG$2:$AU$2;A$2))=1;AG$2;"")

Formel bis AE2 kopieren

Das Ergebnis sieht dann so aus:

<b>Tabelle3</b>

<table border="1" cellspacing="0" cellpadding="0" style="font-family:Arial,Arial; font-size:10pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </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><td >Q</td><td >R</td><td >S</td><td >T</td><td >U</td><td >V</td><td >W</td><td >X</td><td >Y</td><td >Z</td><td >AA</td><td >AB</td><td >AC</td><td >AD</td><td >AE</td><td >AF</td><td >AG</td><td >AH</td><td >AI</td><td >AJ</td><td >AK</td><td >AL</td><td >AM</td><td >AN</td><td >AO</td><td >AP</td><td >AQ</td><td >AR</td><td >AS</td><td >AT</td><td >AU</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">1</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">2</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">3</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">4</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">5</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">6</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">7</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">8</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">9</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">10</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">11</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">12</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">13</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">14</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">15</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; "> </td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">1</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">2</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">3</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">4</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">5</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">6</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">7</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">8</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">9</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">10</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">11</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">12</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">13</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">14</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">15</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; "> </td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">1</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">2</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">3</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">4</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">5</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">6</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">7</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">8</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">9</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">10</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">11</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">12</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">13</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">14</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">15</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; ">5</td><td style="font-weight:bold; text-align:right; ">2</td><td style="font-weight:bold; text-align:right; ">5</td><td style="font-weight:bold; text-align:right; ">5</td><td style="font-weight:bold; text-align:right; ">6</td><td style="font-weight:bold; text-align:right; ">9</td><td style="font-weight:bold; text-align:right; ">9</td><td style="font-weight:bold; text-align:right; ">5</td><td style="font-weight:bold; text-align:right; ">12</td><td style="font-weight:bold; text-align:right; ">14</td><td style="font-weight:bold; text-align:right; ">14</td><td style="font-weight:bold; text-align:right; ">12</td><td style="font-weight:bold; text-align:right; ">12</td><td style="font-weight:bold; text-align:right; ">12</td><td style="font-weight:bold; text-align:right; ">5</td><td style="background-color:#c0c0c0; font-weight:bold; "> </td><td style="font-weight:bold; "> </td><td style="font-weight:bold; "> </td><td style="font-weight:bold; "> </td><td style="font-weight:bold; "> </td><td style="font-weight:bold; "> </td><td style="font-weight:bold; text-align:right; ">9</td><td style="font-weight:bold; "> </td><td style="font-weight:bold; text-align:right; ">5</td><td style="font-weight:bold; "> </td><td style="font-weight:bold; text-align:right; ">14</td><td style="font-weight:bold; "> </td><td style="font-weight:bold; "> </td><td style="font-weight:bold; text-align:right; ">12</td><td style="font-weight:bold; "> </td><td style="font-weight:bold; "> </td><td style="background-color:#c0c0c0; font-weight:bold; "> </td><td style="font-family:Tahoma; text-align:right; ">5</td><td style="font-family:Tahoma; "> </td><td style="font-family:Tahoma; text-align:right; ">5</td><td style="font-family:Tahoma; text-align:right; ">5</td><td style="font-family:Tahoma; "> </td><td style="font-family:Tahoma; text-align:right; ">9</td><td style="font-family:Tahoma; "> </td><td style="font-family:Tahoma; text-align:right; ">5</td><td style="font-family:Tahoma; text-align:right; ">12</td><td style="font-family:Tahoma; text-align:right; ">14</td><td style="font-family:Tahoma; "> </td><td style="font-family:Tahoma; text-align:right; ">12</td><td style="font-family:Tahoma; text-align:right; ">12</td><td style="font-family:Tahoma; "> </td><td style="font-family:Tahoma; "> </td></tr></table>

Excel Tabellen im Web darstellen >> <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>



Wenn Du die Dollarzeichen in den Formeln entfernst kannst Du die Formeln nach unten kopieren

Wenn Du willst kannst Du die Spalten AG-AU verstecken oder noch mehr Spalten einfügen,
sodaß die Hilfsspalten nicht mehr zu sehen sind und Du Platz für weitere eingaben hast.

Gruß PeterSmile

Hier nochmal mit mehreren Reihen gestestet: <b></b> <table border="1" cellspacing="0" cellpadding="0" style="font-fa - Conquistador - 27.03.2013

Hier nochmal mit mehreren Reihen gestestet:

<b></b>

<table border="1" cellspacing="0" cellpadding="0" style="font-family:Arial,Arial; font-size:10pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </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><td >Q</td><td >R</td><td >S</td><td >T</td><td >U</td><td >V</td><td >W</td><td >X</td><td >Y</td><td >Z</td><td >AA</td><td >AB</td><td >AC</td><td >AD</td><td >AE</td><td >AF</td><td >AG</td><td >AH</td><td >AI</td><td >AJ</td><td >AK</td><td >AL</td><td >AM</td><td >AN</td><td >AO</td><td >AP</td><td >AQ</td><td >AR</td><td >AS</td><td >AT</td><td >AU</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">1</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">2</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">3</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">4</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">5</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">6</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">7</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">8</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">9</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">10</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">11</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">12</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">13</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">14</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">15</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; "> </td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">1</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">2</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">3</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">4</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">5</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">6</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">7</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">8</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">9</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">10</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">11</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">12</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">13</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">14</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">15</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; "> </td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">1</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">2</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">3</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">4</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">5</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">6</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">7</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">8</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">9</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">10</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">11</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">12</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">13</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">14</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">15</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; ">5</td><td style="font-weight:bold; text-align:right; ">2</td><td style="font-weight:bold; text-align:right; ">5</td><td style="font-weight:bold; text-align:right; ">5</td><td style="font-weight:bold; text-align:right; ">6</td><td style="font-weight:bold; text-align:right; ">9</td><td style="font-weight:bold; text-align:right; ">9</td><td style="font-weight:bold; text-align:right; ">5</td><td style="font-weight:bold; text-align:right; ">12</td><td style="font-weight:bold; text-align:right; ">14</td><td style="font-weight:bold; text-align:right; ">14</td><td style="font-weight:bold; text-align:right; ">12</td><td style="font-weight:bold; text-align:right; ">12</td><td style="font-weight:bold; text-align:right; ">12</td><td style="font-weight:bold; text-align:right; ">5</td><td style="background-color:#c0c0c0; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; text-align:right; ">9</td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; text-align:right; ">5</td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; text-align:right; ">14</td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; text-align:right; ">12</td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="background-color:#c0c0c0; font-weight:bold; "> </td><td style="font-weight:bold; text-align:right; ">5</td><td style="font-weight:bold; "> </td><td style="font-weight:bold; text-align:right; ">5</td><td style="font-weight:bold; text-align:right; ">5</td><td style="font-weight:bold; "> </td><td style="font-weight:bold; text-align:right; ">9</td><td style="font-weight:bold; "> </td><td style="font-weight:bold; text-align:right; ">5</td><td style="font-weight:bold; text-align:right; ">12</td><td style="font-weight:bold; text-align:right; ">14</td><td style="font-weight:bold; "> </td><td style="font-weight:bold; text-align:right; ">12</td><td style="font-weight:bold; text-align:right; ">12</td><td style="font-weight:bold; "> </td><td style="font-weight:bold; "> </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; ">43</td><td style="font-weight:bold; text-align:right; ">48</td><td style="font-weight:bold; text-align:right; ">49</td><td style="font-weight:bold; text-align:right; ">49</td><td style="font-weight:bold; text-align:right; ">7</td><td style="font-weight:bold; text-align:right; ">6</td><td style="font-weight:bold; text-align:right; ">26</td><td style="font-weight:bold; text-align:right; ">27</td><td style="font-weight:bold; text-align:right; ">32</td><td style="font-weight:bold; text-align:right; ">33</td><td style="font-weight:bold; text-align:right; ">27</td><td style="font-weight:bold; text-align:right; ">28</td><td style="font-weight:bold; text-align:right; ">33</td><td style="font-weight:bold; text-align:right; ">34</td><td style="font-weight:bold; text-align:right; ">11</td><td style="background-color:#c0c0c0; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; text-align:right; ">49</td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; text-align:right; ">27</td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; text-align:right; ">33</td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="background-color:#c0c0c0; "> </td><td style="font-weight:bold; "> </td><td style="font-weight:bold; "> </td><td style="font-weight:bold; text-align:right; ">49</td><td style="font-weight:bold; "> </td><td style="font-weight:bold; "> </td><td style="font-weight:bold; "> </td><td style="font-weight:bold; "> </td><td style="font-weight:bold; text-align:right; ">27</td><td style="font-weight:bold; "> </td><td style="font-weight:bold; text-align:right; ">33</td><td style="font-weight:bold; "> </td><td style="font-weight:bold; "> </td><td style="font-weight:bold; "> </td><td style="font-weight:bold; "> </td><td style="font-weight:bold; "> </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; ">17</td><td style="font-weight:bold; text-align:right; ">20</td><td style="font-weight:bold; text-align:right; ">22</td><td style="font-weight:bold; text-align:right; ">30</td><td style="font-weight:bold; text-align:right; ">33</td><td style="font-weight:bold; text-align:right; ">45</td><td style="font-weight:bold; text-align:right; ">20</td><td style="font-weight:bold; text-align:right; ">6</td><td style="font-weight:bold; text-align:right; ">17</td><td style="font-weight:bold; text-align:right; ">33</td><td style="font-weight:bold; text-align:right; ">33</td><td style="font-weight:bold; text-align:right; ">45</td><td style="font-weight:bold; text-align:right; ">49</td><td style="font-weight:bold; text-align:right; ">1</td><td style="font-weight:bold; text-align:right; ">33</td><td style="background-color:#c0c0c0; "> </td><td style="color:#0000ff; font-weight:bold; text-align:right; ">17</td><td style="color:#0000ff; font-weight:bold; text-align:right; ">20</td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; text-align:right; ">45</td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; text-align:right; ">33</td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="background-color:#c0c0c0; "> </td><td style="font-weight:bold; text-align:right; ">17</td><td style="font-weight:bold; text-align:right; ">20</td><td style="font-weight:bold; "> </td><td style="font-weight:bold; "> </td><td style="font-weight:bold; text-align:right; ">33</td><td style="font-weight:bold; text-align:right; ">45</td><td style="font-weight:bold; "> </td><td style="font-weight:bold; "> </td><td style="font-weight:bold; "> </td><td style="font-weight:bold; text-align:right; ">33</td><td style="font-weight:bold; text-align:right; ">33</td><td style="font-weight:bold; "> </td><td style="font-weight:bold; "> </td><td style="font-weight:bold; "> </td><td style="font-weight:bold; "> </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; ">11</td><td style="font-weight:bold; text-align:right; ">13</td><td style="font-weight:bold; text-align:right; ">15</td><td style="font-weight:bold; text-align:right; ">22</td><td style="font-weight:bold; text-align:right; ">25</td><td style="font-weight:bold; text-align:right; ">33</td><td style="font-weight:bold; text-align:right; ">40</td><td style="font-weight:bold; text-align:right; ">44</td><td style="font-weight:bold; text-align:right; ">49</td><td style="font-weight:bold; text-align:right; ">13</td><td style="font-weight:bold; text-align:right; ">11</td><td style="font-weight:bold; text-align:right; ">28</td><td style="font-weight:bold; text-align:right; ">36</td><td style="font-weight:bold; text-align:right; ">19</td><td style="font-weight:bold; text-align:right; ">14</td><td style="background-color:#c0c0c0; "> </td><td style="color:#0000ff; font-weight:bold; text-align:right; ">11</td><td style="color:#0000ff; font-weight:bold; text-align:right; ">13</td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="background-color:#c0c0c0; "> </td><td style="font-weight:bold; text-align:right; ">11</td><td style="font-weight:bold; text-align:right; ">13</td><td style="font-weight:bold; "> </td><td style="font-weight:bold; "> </td><td style="font-weight:bold; "> </td><td style="font-weight:bold; "> </td><td style="font-weight:bold; "> </td><td style="font-weight:bold; "> </td><td style="font-weight:bold; "> </td><td style="font-weight:bold; "> </td><td style="font-weight:bold; "> </td><td style="font-weight:bold; "> </td><td style="font-weight:bold; "> </td><td style="font-weight:bold; "> </td><td style="font-weight:bold; "> </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; ">7</td><td style="font-weight:bold; text-align:right; ">9</td><td style="font-weight:bold; text-align:right; ">1</td><td style="font-weight:bold; text-align:right; ">6</td><td style="font-weight:bold; text-align:right; ">22</td><td style="font-weight:bold; text-align:right; ">33</td><td style="font-weight:bold; text-align:right; ">44</td><td style="font-weight:bold; text-align:right; ">49</td><td style="font-weight:bold; text-align:right; ">48</td><td style="font-weight:bold; text-align:right; ">32</td><td style="font-weight:bold; text-align:right; ">15</td><td style="font-weight:bold; text-align:right; ">9</td><td style="font-weight:bold; text-align:right; ">44</td><td style="font-weight:bold; text-align:right; ">11</td><td style="font-weight:bold; text-align:right; ">11</td><td style="background-color:#c0c0c0; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; text-align:right; ">9</td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; text-align:right; ">44</td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; text-align:right; ">11</td><td style="color:#0000ff; font-weight:bold; "> </td><td style="background-color:#c0c0c0; "> </td><td style="font-weight:bold; "> </td><td style="font-weight:bold; text-align:right; ">9</td><td style="font-weight:bold; "> </td><td style="font-weight:bold; "> </td><td style="font-weight:bold; "> </td><td style="font-weight:bold; "> </td><td style="font-weight:bold; text-align:right; ">44</td><td style="font-weight:bold; "> </td><td style="font-weight:bold; "> </td><td style="font-weight:bold; "> </td><td style="font-weight:bold; "> </td><td style="font-weight:bold; "> </td><td style="font-weight:bold; "> </td><td style="font-weight:bold; text-align:right; ">11</td><td style="font-weight:bold; "> </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; ">5</td><td style="font-weight:bold; text-align:right; ">8</td><td style="font-weight:bold; text-align:right; ">16</td><td style="font-weight:bold; text-align:right; ">8</td><td style="font-weight:bold; text-align:right; ">9</td><td style="font-weight:bold; text-align:right; ">44</td><td style="font-weight:bold; text-align:right; ">9</td><td style="font-weight:bold; text-align:right; ">36</td><td style="font-weight:bold; text-align:right; ">9</td><td style="font-weight:bold; text-align:right; ">10</td><td style="font-weight:bold; text-align:right; ">25</td><td style="font-weight:bold; text-align:right; ">9</td><td style="font-weight:bold; text-align:right; ">33</td><td style="font-weight:bold; text-align:right; ">17</td><td style="font-weight:bold; text-align:right; ">9</td><td style="background-color:#c0c0c0; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; text-align:right; ">8</td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; text-align:right; ">9</td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="background-color:#c0c0c0; "> </td><td style="font-weight:bold; "> </td><td style="font-weight:bold; text-align:right; ">8</td><td style="font-weight:bold; "> </td><td style="font-weight:bold; "> </td><td style="font-weight:bold; text-align:right; ">9</td><td style="font-weight:bold; "> </td><td style="font-weight:bold; text-align:right; ">9</td><td style="font-weight:bold; "> </td><td style="font-weight:bold; text-align:right; ">9</td><td style="font-weight:bold; "> </td><td style="font-weight:bold; "> </td><td style="font-weight:bold; text-align:right; ">9</td><td style="font-weight:bold; "> </td><td style="font-weight:bold; "> </td><td style="font-weight:bold; "> </td></tr></table>

Excel Tabellen im Web darstellen >> <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>

Hallo Peter K. :wink: ich hatte es auch mit UND Verknüpfungen probiert, war mir aber zu kompliziert und hatte deshalb - Conquistador - 27.03.2013

Hallo Peter K. Wink

ich hatte es auch mit UND Verknüpfungen probiert, war mir aber zu kompliziert und hatte deshalb nach einer "einfacheren" Lösung gesucht :D

Deine Lösung kommt zum gleichen Ergebnis und man benötigt keine Hilfsspalten.

<b>Version Peter K.</b>

<table border="1" cellspacing="0" cellpadding="0" style="font-family:Arial,Arial; font-size:10pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /><col style="width:19px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </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><td >Q</td><td >R</td><td >S</td><td >T</td><td >U</td><td >V</td><td >W</td><td >X</td><td >Y</td><td >Z</td><td >AA</td><td >AB</td><td >AC</td><td >AD</td><td >AE</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >10</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">1</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">2</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">3</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">4</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">5</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">6</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">7</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">8</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">9</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">10</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">11</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">12</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">13</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">14</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">15</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; "> </td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">1</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">2</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">3</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">4</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">5</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">6</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">7</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">8</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">9</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">10</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">11</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">12</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">13</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">14</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">15</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >11</td><td style="font-weight:bold; text-align:right; ">5</td><td style="font-weight:bold; text-align:right; ">2</td><td style="font-weight:bold; text-align:right; ">5</td><td style="font-weight:bold; text-align:right; ">5</td><td style="font-weight:bold; text-align:right; ">6</td><td style="font-weight:bold; text-align:right; ">9</td><td style="font-weight:bold; text-align:right; ">9</td><td style="font-weight:bold; text-align:right; ">5</td><td style="font-weight:bold; text-align:right; ">12</td><td style="font-weight:bold; text-align:right; ">14</td><td style="font-weight:bold; text-align:right; ">14</td><td style="font-weight:bold; text-align:right; ">12</td><td style="font-weight:bold; text-align:right; ">12</td><td style="font-weight:bold; text-align:right; ">12</td><td style="font-weight:bold; text-align:right; ">5</td><td > </td><td style="color:#0000ff; font-weight:bold; text-align:right; ">5</td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; text-align:right; ">9</td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; text-align:right; ">12</td><td style="color:#0000ff; font-weight:bold; text-align:right; ">14</td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >12</td><td style="font-weight:bold; text-align:right; ">43</td><td style="font-weight:bold; text-align:right; ">48</td><td style="font-weight:bold; text-align:right; ">49</td><td style="font-weight:bold; text-align:right; ">49</td><td style="font-weight:bold; text-align:right; ">7</td><td style="font-weight:bold; text-align:right; ">6</td><td style="font-weight:bold; text-align:right; ">26</td><td style="font-weight:bold; text-align:right; ">27</td><td style="font-weight:bold; text-align:right; ">32</td><td style="font-weight:bold; text-align:right; ">33</td><td style="font-weight:bold; text-align:right; ">27</td><td style="font-weight:bold; text-align:right; ">28</td><td style="font-weight:bold; text-align:right; ">33</td><td style="font-weight:bold; text-align:right; ">34</td><td style="font-weight:bold; text-align:right; ">11</td><td > </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; text-align:right; ">49</td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; text-align:right; ">27</td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; text-align:right; ">33</td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >13</td><td style="font-weight:bold; text-align:right; ">17</td><td style="font-weight:bold; text-align:right; ">20</td><td style="font-weight:bold; text-align:right; ">22</td><td style="font-weight:bold; text-align:right; ">30</td><td style="font-weight:bold; text-align:right; ">33</td><td style="font-weight:bold; text-align:right; ">45</td><td style="font-weight:bold; text-align:right; ">20</td><td style="font-weight:bold; text-align:right; ">6</td><td style="font-weight:bold; text-align:right; ">17</td><td style="font-weight:bold; text-align:right; ">33</td><td style="font-weight:bold; text-align:right; ">33</td><td style="font-weight:bold; text-align:right; ">45</td><td style="font-weight:bold; text-align:right; ">49</td><td style="font-weight:bold; text-align:right; ">1</td><td style="font-weight:bold; text-align:right; ">33</td><td > </td><td style="color:#0000ff; font-weight:bold; text-align:right; ">17</td><td style="color:#0000ff; font-weight:bold; text-align:right; ">20</td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; text-align:right; ">33</td><td style="color:#0000ff; font-weight:bold; text-align:right; ">45</td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >14</td><td style="font-weight:bold; text-align:right; ">11</td><td style="font-weight:bold; text-align:right; ">13</td><td style="font-weight:bold; text-align:right; ">15</td><td style="font-weight:bold; text-align:right; ">22</td><td style="font-weight:bold; text-align:right; ">25</td><td style="font-weight:bold; text-align:right; ">33</td><td style="font-weight:bold; text-align:right; ">40</td><td style="font-weight:bold; text-align:right; ">44</td><td style="font-weight:bold; text-align:right; ">49</td><td style="font-weight:bold; text-align:right; ">13</td><td style="font-weight:bold; text-align:right; ">11</td><td style="font-weight:bold; text-align:right; ">28</td><td style="font-weight:bold; text-align:right; ">36</td><td style="font-weight:bold; text-align:right; ">19</td><td style="font-weight:bold; text-align:right; ">14</td><td > </td><td style="color:#0000ff; font-weight:bold; text-align:right; ">11</td><td style="color:#0000ff; font-weight:bold; text-align:right; ">13</td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >15</td><td style="font-weight:bold; text-align:right; ">7</td><td style="font-weight:bold; text-align:right; ">9</td><td style="font-weight:bold; text-align:right; ">1</td><td style="font-weight:bold; text-align:right; ">6</td><td style="font-weight:bold; text-align:right; ">22</td><td style="font-weight:bold; text-align:right; ">33</td><td style="font-weight:bold; text-align:right; ">44</td><td style="font-weight:bold; text-align:right; ">49</td><td style="font-weight:bold; text-align:right; ">48</td><td style="font-weight:bold; text-align:right; ">32</td><td style="font-weight:bold; text-align:right; ">15</td><td style="font-weight:bold; text-align:right; ">9</td><td style="font-weight:bold; text-align:right; ">44</td><td style="font-weight:bold; text-align:right; ">11</td><td style="font-weight:bold; text-align:right; ">11</td><td > </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; text-align:right; ">9</td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; text-align:right; ">44</td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; text-align:right; ">11</td><td style="color:#0000ff; font-weight:bold; "> </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >16</td><td style="font-weight:bold; text-align:right; ">5</td><td style="font-weight:bold; text-align:right; ">8</td><td style="font-weight:bold; text-align:right; ">16</td><td style="font-weight:bold; text-align:right; ">8</td><td style="font-weight:bold; text-align:right; ">9</td><td style="font-weight:bold; text-align:right; ">44</td><td style="font-weight:bold; text-align:right; ">9</td><td style="font-weight:bold; text-align:right; ">36</td><td style="font-weight:bold; text-align:right; ">9</td><td style="font-weight:bold; text-align:right; ">10</td><td style="font-weight:bold; text-align:right; ">25</td><td style="font-weight:bold; text-align:right; ">9</td><td style="font-weight:bold; text-align:right; ">33</td><td style="font-weight:bold; text-align:right; ">17</td><td style="font-weight:bold; text-align:right; ">9</td><td > </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; text-align:right; ">8</td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; text-align:right; ">9</td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td><td style="color:#0000ff; font-weight:bold; "> </td></tr></table>

Excel Tabellen im Web darstellen >> <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>






Gruß Peter

Hallo Peter, bei mir war es gerade umgekehrt. Ich habe die Hilfsspaltenlösung verworfen, weil mir die Datei - Peter K. - 27.03.2013

Hallo Peter,

bei mir war es gerade umgekehrt.

Ich habe die Hilfsspaltenlösung verworfen, weil mir die Datei zu aufgebläht würde.

Vor allem, wenn die Basisdatei mal verbreitert würde.

Danke für das Querlesen. Wink

Beste Grüße

Peter K.

@ Skipper : ist die Datei angekommen und kannst Du die einlesen ?

.

[quote][i]Original von Peter K.[/i] Hallo Peter, bei mir war es gerade umgekehrt. Ich habe die Hilfsspalten - Conquistador - 27.03.2013

Zitat:Original von Peter K.
Hallo Peter,

bei mir war es gerade umgekehrt.

Ich habe die Hilfsspaltenlösung verworfen, weil mir die Datei zu aufgebläht würde.

Vor allem, wenn die Basisdatei mal verbreitert würde.

Danke für das Querlesen. Wink

Beste Grüße

Peter K.

.

Darum finde ich Deine Version auch besser Daumen hoch


Zitat:@Peter(Conquistador) dem Excelking : Bitte mal auf logische Fehler checken, Danke.

Der Titel steht mir gar nicht zu, habe leider nur Grundwissen

Und daß das ganze hier als Co Produktion lief find ich auch toll Daumen hoch Daumen hoch


Gruß PeterSmile

Hallo Peter Conquistador, Peter K. :wink: ich möchte mich Herzlich Bedanken, für den eMail und für die Lösung, für - Skipper - 28.03.2013

Hallo Peter Conquistador, Peter K. Wink

ich möchte mich Herzlich Bedanken, für den eMail und für
die Lösung, für mich war nicht so einfach...
weil die Formel: "SUMMENPRODUKT" habe ich bis gestern
noch nicht angewendet in Excel-Tabellen, es war mir unbekannt
bei welche Aufgabe kann diese Formel-Funktion anwenden.

Vielen Vielen Dank

Ps.: seid die Beste Daumen hoch