Themabewertung:
  • 0 Bewertung(en) - 0 im Durchschnitt
  • 1
  • 2
  • 3
  • 4
  • 5
Hilfe bei Excel Tabelle
#11
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 ???
Sincerely,
Smile
Zitieren

#12
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.

.
Zitieren

#13
Hallo Peter K. Wink

Du hast eine e-Mail mit Datei.

1000 Dank
Sincerely,
Smile
Zitieren

#14
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.

.
Zitieren

#15
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
Erfahrung ist eine nützliche Sache.
Leider macht man sie immer erst kurz nachdem man sie brauchte.
Zitieren

#16
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>
Erfahrung ist eine nützliche Sache.
Leider macht man sie immer erst kurz nachdem man sie brauchte.
Zitieren

#17
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
Erfahrung ist eine nützliche Sache.
Leider macht man sie immer erst kurz nachdem man sie brauchte.
Zitieren

#18
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 ?

.
Zitieren

#19
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
Erfahrung ist eine nützliche Sache.
Leider macht man sie immer erst kurz nachdem man sie brauchte.
Zitieren

#20
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
Sincerely,
Smile
Zitieren



Gehe zu:


Benutzer, die gerade dieses Thema anschauen:
2 Gast/Gäste

Deutsche Übersetzung: MyBB.de, Powered by MyBB 1.8.36, © 2002-2024 Melroy van den Berg.