PDA

Vollständige Version anzeigen : Wahlexcel mit Rangliste - Real time


wesentlich
28.02.2008, 16:15
Hallo Leute,

ich würde gerne bei unserer Vorstandwahl morgen (!) live die Wahlzettel am Beamer auswerten, dazu habe ich folgende Excle angefangen:
#####
Wahlberechtigte 0
ja Nein
1. Vorsitzender
2. Vorsitzender
Kassier
Schriftführer
1. Beisitzer Name 1
2. Beisitzer Name 2
3. Beisitzer Name 3
4. Beisitzer Name 4
5. Beisitzer Name 5

Kassenprüfer 1
Kassenprüfer 2

geheime Wahlen
1 3 4 1 2 3 8 1
Name 1 Name 2 Name 3 Name 4 Name 5 Name 6 Name 7 Name 8
#############

Es geht um die Beisitzer.
In den Zellen A-H19 bis A-HXX will ich live jeweils beim vorlesen der Namen eine 1 Eintragen.
Summiert wird dann in Zeile 17. in Zeile 18 gebe ich voher die Namen ein.
Nun soll in Abhängigkeit von der Anzahl der Stimmen eine Reihenfolge der Namen in E7-E11 erscheinen. Was sich natürlich die ganze Wahl über verändern kann.

Habt Ihr eine Idee?

Vielen Dank und Gruß
Stefancontact@stefan-schreiner.de

Berti_S
28.02.2008, 16:27
Hallo Stefan,

die live-Anzeige ist ja gut und schön, problematisch aber bei Stimmengleichheit.

Wie soll denn dann die Anzeige aussehen ?

Berti

IngGi
28.02.2008, 16:42
Hallo Stefan,

wegen des Problems mit identischen Stimmzahlen mit zwei Hilfszeilen (17 & 18), die du natürlich ausblenden kannst:
<table><tr style="vertical-align:top; text-align:center; "><tr><td>&nbsp;</td></tr><tr><td><table border=1 cellspacing=0 cellpadding=0 style="font-family:Arial,Arial; font-size:10pt; padding-left:2pt; padding-right:2pt; "> <style type = "text/css"> th {font-weight:normal} </style> <colgroup><col width=30 ><col width=73.99999815 ><col width=73.99999815 ><col width=73.99999815 ><col width=73.99999815 ><col width=73.99999815 ><col width=73.99999815 ><col width=73.99999815 ><col width=73.99999815 ></colgroup><tr style="background-color:#cacaca; text-align:center;font-size:8pt; "><td>&nbsp;</td><td>A</td><td>B</td><td>C</td><td>D</td><td>E</td><td>F</td><td>G</td><td>H</td></tr><tr height=24 ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><th colspan="3" rowspan="1" style="font-size:14pt; text-align:left; font-weight:bold; ">Wahlberechtigte</th><td style="font-size:14pt; text-align:center; ">0</td><td style="text-align:center; font-weight:bold; ">&nbsp;</td><td style="text-align:center; font-weight:bold; ">&nbsp;</td><td style="">&nbsp;</td><td style="">&nbsp;</td></tr><tr height=24 ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td style="">&nbsp;</td><td style="">&nbsp;</td><td style="">&nbsp;</td><td style="text-align:center; font-weight:bold; ">&nbsp;</td><td style="text-align:center; font-weight:bold; ">&nbsp;</td><td style="text-align:center; font-weight:bold; ">&nbsp;</td><td style="font-size:14pt; text-align:center; ">ja</td><td style="font-size:14pt; text-align:center; ">Nein</td></tr><tr height=24 ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><th colspan="3" rowspan="1" style="font-size:14pt; text-align:left; font-weight:bold; ">1. Vorsitzender</th><th colspan="3" rowspan="1" style="font-size:14pt; text-align:center; ">&nbsp;</th><td style="font-size:14pt; ">&nbsp;</td><td style="font-size:14pt; ">&nbsp;</td></tr><tr height=24 ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><th colspan="3" rowspan="1" style="font-size:14pt; text-align:left; font-weight:bold; ">2. Vorsitzender</th><th colspan="3" rowspan="1" style="font-size:14pt; text-align:center; ">&nbsp;</th><td style="font-size:14pt; ">&nbsp;</td><td style="font-size:14pt; ">&nbsp;</td></tr><tr height=24 ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><th colspan="3" rowspan="1" style="font-size:14pt; text-align:left; font-weight:bold; ">Kassier</th><th colspan="3" rowspan="1" style="font-size:14pt; text-align:center; ">&nbsp;</th><td style="font-size:14pt; ">&nbsp;</td><td style="font-size:14pt; ">&nbsp;</td></tr><tr height=24 ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><th colspan="3" rowspan="1" style="font-size:14pt; text-align:left; font-weight:bold; ">Schriftf&uuml;hrer</th><th colspan="3" rowspan="1" style="font-size:14pt; text-align:center; ">&nbsp;</th><td style="font-size:14pt; ">&nbsp;</td><td style="font-size:14pt; ">&nbsp;</td></tr><tr height=24 ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >7</td><th colspan="3" rowspan="1" style="font-size:14pt; text-align:left; font-weight:bold; ">1. Beisitzer</th><th colspan="3" rowspan="1" style="font-size:14pt; text-align:center; ">Name 1</th><td style="font-size:14pt; ">&nbsp;</td><td style="font-size:14pt; ">&nbsp;</td></tr><tr height=24 ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >8</td><th colspan="3" rowspan="1" style="font-size:14pt; text-align:left; font-weight:bold; ">2. Beisitzer</th><th colspan="3" rowspan="1" style="font-size:14pt; text-align:center; ">Name 2</th><td style="font-size:14pt; ">&nbsp;</td><td style="font-size:14pt; ">&nbsp;</td></tr><tr height=24 ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >9</td><th colspan="3" rowspan="1" style="font-size:14pt; text-align:left; font-weight:bold; ">3. Beisitzer</th><th colspan="3" rowspan="1" style="font-size:14pt; text-align:center; ">Name 3</th><td style="font-size:14pt; ">&nbsp;</td><td style="font-size:14pt; ">&nbsp;</td></tr><tr height=24 ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >10</td><th colspan="3" rowspan="1" style="font-size:14pt; text-align:left; font-weight:bold; ">4. Beisitzer</th><th colspan="3" rowspan="1" style="font-size:14pt; text-align:center; ">Name 4</th><td style="font-size:14pt; ">&nbsp;</td><td style="font-size:14pt; ">&nbsp;</td></tr><tr height=24 ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >11</td><th colspan="3" rowspan="1" style="font-size:14pt; text-align:left; font-weight:bold; ">5. Beisitzer</th><th colspan="3" rowspan="1" style="font-size:14pt; text-align:center; ">Name 5</th><td style="font-size:14pt; ">&nbsp;</td><td style="font-size:14pt; ">&nbsp;</td></tr><tr height=24 ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >12</td><th colspan="3" rowspan="1" style="font-size:14pt; text-align:left; font-weight:bold; ">&nbsp;</th><td style="font-size:14pt; ">&nbsp;</td><td style="font-size:14pt; ">&nbsp;</td><td style="font-size:14pt; ">&nbsp;</td><td style="font-size:14pt; ">&nbsp;</td><td style="font-size:14pt; ">&nbsp;</td></tr><tr height=24 ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >13</td><th colspan="3" rowspan="1" style="font-size:14pt; text-align:left; font-weight:bold; ">Kassenpr&uuml;fer 1</th><th colspan="3" rowspan="1" style="font-size:14pt; text-align:center; ">&nbsp;</th><td style="font-size:14pt; ">&nbsp;</td><td style="font-size:14pt; ">&nbsp;</td></tr><tr height=24 ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >14</td><th colspan="3" rowspan="1" style="font-size:14pt; text-align:left; font-weight:bold; ">Kassenpr&uuml;fer 2</th><th colspan="3" rowspan="1" style="font-size:14pt; text-align:center; ">&nbsp;</th><td style="font-size:14pt; ">&nbsp;</td><td style="font-size:14pt; ">&nbsp;</td></tr><tr height=24 ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >15</td><td style="font-size:14pt; font-weight:bold; ">&nbsp;</td><td style="font-size:14pt; ">&nbsp;</td><td style="font-size:14pt; ">&nbsp;</td><td style="font-size:14pt; ">&nbsp;</td><td style="font-size:14pt; ">&nbsp;</td><td style="font-size:14pt; ">&nbsp;</td><td style="font-size:14pt; ">&nbsp;</td><td style="font-size:14pt; ">&nbsp;</td></tr><tr height=24 ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >16</td><th colspan="8" rowspan="1" style="font-size:14pt; text-align:center; ">geheime Wahlen</th></tr><tr height=24 ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >17</td><td style="font-size:14pt; text-align:center; ">1</td><td style="font-size:14pt; text-align:center; ">2</td><td style="font-size:14pt; text-align:center; ">3</td><td style="font-size:14pt; text-align:center; ">4</td><td style="font-size:14pt; text-align:center; ">5</td><td style="font-size:14pt; text-align:center; ">6</td><td style="font-size:14pt; text-align:center; ">7</td><td style="font-size:14pt; text-align:center; ">8</td></tr><tr height=24 ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >18</td><td style="font-size:14pt; text-align:center; ">1</td><td style="font-size:14pt; text-align:center; ">1</td><td style="font-size:14pt; text-align:center; ">1</td><td style="font-size:14pt; text-align:center; ">1</td><td style="font-size:14pt; text-align:center; ">1</td><td style="font-size:14pt; text-align:center; ">1</td><td style="font-size:14pt; text-align:center; ">1</td><td style="font-size:14pt; text-align:center; ">1</td></tr><tr height=24 ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >19</td><td style="font-size:14pt; text-align:center; ">0</td><td style="font-size:14pt; text-align:center; ">0</td><td style="font-size:14pt; text-align:center; ">0</td><td style="font-size:14pt; text-align:center; ">0</td><td style="font-size:14pt; text-align:center; ">0</td><td style="font-size:14pt; text-align:center; ">0</td><td style="font-size:14pt; text-align:center; ">0</td><td style="font-size:14pt; text-align:center; ">0</td></tr><tr height=21 ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >20</td><td style="font-size:12pt; text-align:center; font-weight:bold; ">Name 1</td><td style="font-size:12pt; text-align:center; font-weight:bold; ">Name 2</td><td style="font-size:12pt; text-align:center; font-weight:bold; ">Name 3</td><td style="font-size:12pt; text-align:center; font-weight:bold; ">Name 4</td><td style="font-size:12pt; text-align:center; font-weight:bold; ">Name 5</td><td style="font-size:12pt; text-align:center; font-weight:bold; ">Name 6</td><td style="font-size:12pt; text-align:center; font-weight:bold; ">Name 7</td><td style="font-size:12pt; text-align:center; font-weight:bold; ">Name 8</td></tr></table><table style="font-family:Arial; font-size:10pt; border-style: groove ;border-color:#00ff00;background-color:#FFFCF9; "><tr><td><b>Formeln der Tabelle</b></td></tr><tr><td><table style="font-family:Arial; font-size:10pt;">D7 : =INDEX($A$20:$H$20;VERGLEICH(ZEILE()-6;$A$17:$H$17;0))<br>D8 : =INDEX($A$20:$H$20;VERGLEICH(ZEILE()-6;$A$17:$H$17;0))<br>D9 : =INDEX($A$20:$H$20;VERGLEICH(ZEILE()-6;$A$17:$H$17;0))<br>D10 : =INDEX($A$20:$H$20;VERGLEICH(ZEILE()-6;$A$17:$H$17;0))<br>D11 : =INDEX($A$20:$H$20;VERGLEICH(ZEILE()-6;$A$17:$H$17;0))<br>A17 : =RANG(A19;$A$19:$H$19)<br>B17 : =RANG(B19;$A$19:$H$19)+Z&Auml;HLENWENN($A$18:A18;"="&RANG(B19;$A$19:$H$19))<br>C17 : =RANG(C19;$A$19:$H$19)+Z&Auml;HLENWENN($A$18:B18;"="&RANG(C19;$A$19:$H$19))<br>D17 : =RANG(D19;$A$19:$H$19)+Z&Auml;HLENWENN($A$18:C18;"="&RANG(D19;$A$19:$H$19))<br>E17 : =RANG(E19;$A$19:$H$19)+Z&Auml;HLENWENN($A$18:D18;"="&RANG(E19;$A$19:$H$19))<br>F17 : =RANG(F19;$A$19:$H$19)+Z&Auml;HLENWENN($A$18:E18;"="&RANG(F19;$A$19:$H$19))<br>G17 : =RANG(G19;$A$19:$H$19)+Z&Auml;HLENWENN($A$18:F18;"="&RANG(G19;$A$19:$H$19))<br>H17 : =RANG(H19;$A$19:$H$19)+Z&Auml;HLENWENN($A$18:G18;"="&RANG(H19;$A$19:$H$19))<br>A18 : =RANG(A19;$A$19:$H$19)<br>B18 : =RANG(B19;$A$19:$H$19)<br>C18 : =RANG(C19;$A$19:$H$19)<br>D18 : =RANG(D19;$A$19:$H$19)<br>E18 : =RANG(E19;$A$19:$H$19)<br>F18 : =RANG(F19;$A$19:$H$19)<br>G18 : =RANG(G19;$A$19:$H$19)<br>H18 : =RANG(H19;$A$19:$H$19)<br>A19 : =SUMME(A21:A150)<br>B19 : =SUMME(B21:B150)<br>C19 : =SUMME(C21:C150)<br>D19 : =SUMME(D21:D150)<br>E19 : =SUMME(E21:E150)<br>F19 : =SUMME(F21:F150)<br>G19 : =SUMME(G21:G150)<br>H19 : =SUMME(H21:H150)<br></table></td></tr></table></td></tr><tr><td>&nbsp;</td></tr></tr></table>Gruß Ingolf

wesentlich
28.02.2008, 18:02
Hey Ingolf,

Klasse vielen Dank!!!
Funzt einwandfrei

Gruß
Stefan