PDA

Vollständige Version anzeigen : Excel 2003 Zahlen weiter zählenn


Kahiiooss
06.04.2012, 08:51
Hallo Zusammen,
wie kann ich die Zeilen so runter ziehen, dass die folgende zeilen ergänzt werden?
Ohne VBA!
Alles ist inderselben Spalte und ich möchte diese runter ziehen, damit die zahlen weiter gehen bis 1.000:

0
0
0
Eingabe
0
0
1
Eingabe
0
0
2
Eingabe
0
0
3
Eingabe
0
0
4
Eingabe
0
0
5
Eingabe
0
0
6
Eingabe
0
0
7
Eingabe
0
0
8
Eingabe
0
0
9
Eingabe
0
1
0
Eingabe
0
1
1
Eingabe
0
1
2
Eingabe

Hajo_Zi
06.04.2012, 08:57
markiere A5:A8 und ziehe es runter.

<b><em>Tabelle1</em></b><table border="1" cellspacing="0" cellpadding="0" style="border-color:#000000; border-width: 1px; font-size:11pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "><colgroup><col style="font-weight:bold; width:40px;" /><col style="width:126px;" /></colgroup><tr style="background-color:#99CCFF; text-align:center; font-weight:bold; "><td>&nbsp;</td><td>A</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">1</td><td style="color:#000000; background-color:#FFFFFF; text-align:right; " >0</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">2</td><td style="color:#000000; background-color:#FFFFFF; text-align:right; " >0</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">3</td><td style="color:#000000; background-color:#FFFFFF; text-align:right; " >0</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">4</td><td style="color:#000000; background-color:#FFFFFF; text-align:left; " >Eingabe</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">5</td><td style="color:#000000; background-color:#FFFFFF; text-align:right; " >0</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">6</td><td style="color:#000000; background-color:#FFFFFF; text-align:right; " >0</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">7</td><td style="color:#000000; background-color:#FFFFFF; text-align:right; " >1</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">8</td><td style="color:#000000; background-color:#FFFFFF; text-align:left; " >Eingabe</td></tr></table><br/><table border="1" cellspacing="0" cellpadding="0" style="border-color:#000000; border-width: 1px; font-size:11pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "><tr style="background-color:#FFCC66; text-align:center; font-weight:bold; "><td colspan="3" > verwendete Formeln </td></tr><tr valign="top" style="background-color:#FFCC66; text-align:center; font-weight:bold; "><td> Zelle </td><td> Formel </td><td> Bereich </td></tr><tr><td>A5 </td><td>=WENN(A2=9;A1+1;A1)</td><td>&nbsp;</td></tr><tr><td>A6 </td><td>=WENN(A3=9;A2+1;A2)</td><td>&nbsp;</td></tr><tr><td>A7 </td><td>=WENN(A3=9;0;A3+1)</td><td>&nbsp;</td></tr></table><br/><a href="http://excel-inn.de/dateien/vba_beispiele/tabellenanzeige_in_html_addin.zip" onclick="window.open(this.href);return false">Tabellendarstellung in Foren Version 5.48</a><br/><br/>

<img src="http://Hajo-Excel.de/images/grusz1.gif" align="middle" height="40" alt="Grußformel"><a href="http://Hajo-Excel.de/index.htm" onclick="window.open(this.href);return false"><img border="0" src="http://Hajo-Excel.de/images/logo_hajo3.gif" align="middle" height="40" alt="Homepage"></a>

Kahiiooss
06.04.2012, 09:09
Super

Dankeschön Hajo..
Fetter Kuss

Kahiiooss
06.04.2012, 09:16
Och nöö, das geht nur bis

Eingabe
0
9
0
Eingabe


ab da, geht's nicht mehr weiter bzw. falsch :( Ich möchte es aber bis 1000 ziehen. :(

Hajo_Zi
06.04.2012, 09:27
ich habe es soweit gezogen wie in Deiner Liste und habe genau die Ergebnisse.

<b><em>Tabelle1</em></b><table border="1" cellspacing="0" cellpadding="0" style="border-color:#000000; border-width: 1px; font-size:11pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "><colgroup><col style="font-weight:bold; width:40px;" /><col style="width:126px;" /></colgroup><tr style="background-color:#99CCFF; text-align:center; font-weight:bold; "><td>&nbsp;</td><td>A</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">1</td><td style="color:#000000; background-color:#FFFFFF; text-align:right; " >0</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">2</td><td style="color:#000000; background-color:#FFFFFF; text-align:right; " >0</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">3</td><td style="color:#000000; background-color:#FFFFFF; text-align:right; " >0</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">4</td><td style="color:#000000; background-color:#FFFFFF; text-align:left; " >Eingabe</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">5</td><td style="color:#000000; background-color:#FFFFFF; text-align:right; " >0</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">6</td><td style="color:#000000; background-color:#FFFFFF; text-align:right; " >0</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">7</td><td style="color:#000000; background-color:#FFFFFF; text-align:right; " >1</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">8</td><td style="color:#000000; background-color:#FFFFFF; text-align:left; " >Eingabe</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">9</td><td style="color:#000000; background-color:#FFFFFF; text-align:right; " >0</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">10</td><td style="color:#000000; background-color:#FFFFFF; text-align:right; " >0</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">11</td><td style="color:#000000; background-color:#FFFFFF; text-align:right; " >2</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">12</td><td style="color:#000000; background-color:#FFFFFF; text-align:left; " >Eingabe</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">13</td><td style="color:#000000; background-color:#FFFFFF; text-align:right; " >0</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">14</td><td style="color:#000000; background-color:#FFFFFF; text-align:right; " >0</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">15</td><td style="color:#000000; background-color:#FFFFFF; text-align:right; " >3</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">16</td><td style="color:#000000; background-color:#FFFFFF; text-align:left; " >Eingabe</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">17</td><td style="color:#000000; background-color:#FFFFFF; text-align:right; " >0</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">18</td><td style="color:#000000; background-color:#FFFFFF; text-align:right; " >0</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">19</td><td style="color:#000000; background-color:#FFFFFF; text-align:right; " >4</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">20</td><td style="color:#000000; background-color:#FFFFFF; text-align:left; " >Eingabe</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">21</td><td style="color:#000000; background-color:#FFFFFF; text-align:right; " >0</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">22</td><td style="color:#000000; background-color:#FFFFFF; text-align:right; " >0</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">23</td><td style="color:#000000; background-color:#FFFFFF; text-align:right; " >5</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">24</td><td style="color:#000000; background-color:#FFFFFF; text-align:left; " >Eingabe</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">25</td><td style="color:#000000; background-color:#FFFFFF; text-align:right; " >0</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">26</td><td style="color:#000000; background-color:#FFFFFF; text-align:right; " >0</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">27</td><td style="color:#000000; background-color:#FFFFFF; text-align:right; " >6</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">28</td><td style="color:#000000; background-color:#FFFFFF; text-align:left; " >Eingabe</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">29</td><td style="color:#000000; background-color:#FFFFFF; text-align:right; " >0</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">30</td><td style="color:#000000; background-color:#FFFFFF; text-align:right; " >0</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">31</td><td style="color:#000000; background-color:#FFFFFF; text-align:right; " >7</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">32</td><td style="color:#000000; background-color:#FFFFFF; text-align:left; " >Eingabe</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">33</td><td style="color:#000000; background-color:#FFFFFF; text-align:right; " >0</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">34</td><td style="color:#000000; background-color:#FFFFFF; text-align:right; " >0</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">35</td><td style="color:#000000; background-color:#FFFFFF; text-align:right; " >8</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">36</td><td style="color:#000000; background-color:#FFFFFF; text-align:left; " >Eingabe</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">37</td><td style="color:#000000; background-color:#FFFFFF; text-align:right; " >0</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">38</td><td style="color:#000000; background-color:#FFFFFF; text-align:right; " >0</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">39</td><td style="color:#000000; background-color:#FFFFFF; text-align:right; " >9</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">40</td><td style="color:#000000; background-color:#FFFFFF; text-align:left; " >Eingabe</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">41</td><td style="color:#000000; background-color:#FFFFFF; text-align:right; " >0</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">42</td><td style="color:#000000; background-color:#FFFFFF; text-align:right; " >1</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">43</td><td style="color:#000000; background-color:#FFFFFF; text-align:right; " >0</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">44</td><td style="color:#000000; background-color:#FFFFFF; text-align:left; " >Eingabe</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">45</td><td style="color:#000000; background-color:#FFFFFF; text-align:right; " >0</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">46</td><td style="color:#000000; background-color:#FFFFFF; text-align:right; " >1</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">47</td><td style="color:#000000; background-color:#FFFFFF; text-align:right; " >1</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">48</td><td style="color:#000000; background-color:#FFFFFF; text-align:left; " >Eingabe</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">49</td><td style="color:#000000; background-color:#FFFFFF; text-align:right; " >0</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">50</td><td style="color:#000000; background-color:#FFFFFF; text-align:right; " >1</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">51</td><td style="color:#000000; background-color:#FFFFFF; text-align:right; " >2</td></tr></table><br/><table border="1" cellspacing="0" cellpadding="0" style="border-color:#000000; border-width: 1px; font-size:11pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "><tr style="background-color:#FFCC66; text-align:center; font-weight:bold; "><td colspan="3" > verwendete Formeln </td></tr><tr valign="top" style="background-color:#FFCC66; text-align:center; font-weight:bold; "><td> Zelle </td><td> Formel </td><td> Bereich </td></tr><tr><td>A5 </td><td>=WENN(A2=9;A1+1;A1)</td><td>&nbsp;</td></tr><tr><td>A6 </td><td>=WENN(A3=9;A2+1;A2)</td><td>&nbsp;</td></tr><tr><td>A7 </td><td>=WENN(A3=9;0;A3+1)</td><td>&nbsp;</td></tr><tr><td>A9 </td><td>=WENN(A6=9;A5+1;A5)</td><td>&nbsp;</td></tr><tr><td>A10 </td><td>=WENN(A7=9;A6+1;A6)</td><td>&nbsp;</td></tr><tr><td>A11 </td><td>=WENN(A7=9;0;A7+1)</td><td>&nbsp;</td></tr><tr><td>A13 </td><td>=WENN(A10=9;A9+1;A9)</td><td>&nbsp;</td></tr><tr><td>A14 </td><td>=WENN(A11=9;A10+1;A10)</td><td>&nbsp;</td></tr><tr><td>A15 </td><td>=WENN(A11=9;0;A11+1)</td><td>&nbsp;</td></tr><tr><td>A17 </td><td>=WENN(A14=9;A13+1;A13)</td><td>&nbsp;</td></tr><tr><td>A18 </td><td>=WENN(A15=9;A14+1;A14)</td><td>&nbsp;</td></tr><tr><td>A19 </td><td>=WENN(A15=9;0;A15+1)</td><td>&nbsp;</td></tr><tr><td>A21 </td><td>=WENN(A18=9;A17+1;A17)</td><td>&nbsp;</td></tr><tr><td>A22 </td><td>=WENN(A19=9;A18+1;A18)</td><td>&nbsp;</td></tr><tr><td>A23 </td><td>=WENN(A19=9;0;A19+1)</td><td>&nbsp;</td></tr><tr><td>A25 </td><td>=WENN(A22=9;A21+1;A21)</td><td>&nbsp;</td></tr><tr><td>A26 </td><td>=WENN(A23=9;A22+1;A22)</td><td>&nbsp;</td></tr><tr><td>A27 </td><td>=WENN(A23=9;0;A23+1)</td><td>&nbsp;</td></tr><tr><td>A29 </td><td>=WENN(A26=9;A25+1;A25)</td><td>&nbsp;</td></tr><tr><td>A30 </td><td>=WENN(A27=9;A26+1;A26)</td><td>&nbsp;</td></tr><tr><td>A31 </td><td>=WENN(A27=9;0;A27+1)</td><td>&nbsp;</td></tr><tr><td>A33 </td><td>=WENN(A30=9;A29+1;A29)</td><td>&nbsp;</td></tr><tr><td>A34 </td><td>=WENN(A31=9;A30+1;A30)</td><td>&nbsp;</td></tr><tr><td>A35 </td><td>=WENN(A31=9;0;A31+1)</td><td>&nbsp;</td></tr><tr><td>A37 </td><td>=WENN(A34=9;A33+1;A33)</td><td>&nbsp;</td></tr><tr><td>A38 </td><td>=WENN(A35=9;A34+1;A34)</td><td>&nbsp;</td></tr><tr><td>A39 </td><td>=WENN(A35=9;0;A35+1)</td><td>&nbsp;</td></tr><tr><td>A41 </td><td>=WENN(A38=9;A37+1;A37)</td><td>&nbsp;</td></tr><tr><td>A42 </td><td>=WENN(A39=9;A38+1;A38)</td><td>&nbsp;</td></tr><tr><td>A43 </td><td>=WENN(A39=9;0;A39+1)</td><td>&nbsp;</td></tr><tr><td>A45 </td><td>=WENN(A42=9;A41+1;A41)</td><td>&nbsp;</td></tr><tr><td>A46 </td><td>=WENN(A43=9;A42+1;A42)</td><td>&nbsp;</td></tr><tr><td>A47 </td><td>=WENN(A43=9;0;A43+1)</td><td>&nbsp;</td></tr><tr><td>A49 </td><td>=WENN(A46=9;A45+1;A45)</td><td>&nbsp;</td></tr><tr><td>A50 </td><td>=WENN(A47=9;A46+1;A46)</td><td>&nbsp;</td></tr><tr><td>A51 </td><td>=WENN(A47=9;0;A47+1)</td><td>&nbsp;</td></tr></table><br/><a href="http://excel-inn.de/dateien/vba_beispiele/tabellenanzeige_in_html_addin.zip" onclick="window.open(this.href);return false">Tabellendarstellung in Foren Version 5.48</a><br/><br/>
was in Zeile 1000 sterhen soll Stand nicht im Beitrag.

<a href="http://Hajo-Excel.de/index.htm" target="_blank" title="Hajo's Excelseiten">Gruß Hajo</a>

Kahiiooss
06.04.2012, 09:40
2
9
0
Eingabe
3
9
1
Eingabe
4
9
2
Kommt mit der Formel, statt:
Eingabe
2
9
1
Eingabe
2
9
2
usw..

Es reicht schon, wenn es bis 999 geht..

Hajo_Zi
06.04.2012, 09:47
bei mir sieht die Zeille 999 anders aus. Ich sehe aber nicht Deine Datei

<b><em>Tabelle1</em></b><table border="1" cellspacing="0" cellpadding="0" style="border-color:#000000; border-width: 1px; font-size:11pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "><colgroup><col style="font-weight:bold; width:40px;" /><col style="width:126px;" /></colgroup><tr style="background-color:#99CCFF; text-align:center; font-weight:bold; "><td>&nbsp;</td><td>A</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">997</td><td style="color:#000000; background-color:#FFFFFF; text-align:right; " >10</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">998</td><td style="color:#000000; background-color:#FFFFFF; text-align:right; " >24</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">999</td><td style="color:#000000; background-color:#FFFFFF; text-align:right; " >9</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">1000</td><td style="color:#000000; background-color:#FFFFFF; text-align:left; " >Eingabe</td></tr></table><br/><table border="1" cellspacing="0" cellpadding="0" style="border-color:#000000; border-width: 1px; font-size:11pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "><tr style="background-color:#FFCC66; text-align:center; font-weight:bold; "><td colspan="3" > verwendete Formeln </td></tr><tr valign="top" style="background-color:#FFCC66; text-align:center; font-weight:bold; "><td> Zelle </td><td> Formel </td><td> Bereich </td></tr><tr><td>A997 </td><td>=WENN(A994=9;A993+1;A993)</td><td>&nbsp;</td></tr><tr><td>A998 </td><td>=WENN(A995=9;A994+1;A994)</td><td>&nbsp;</td></tr><tr><td>A999 </td><td>=WENN(A995=9;0;A995+1)</td><td>&nbsp;</td></tr></table><br/><a href="http://excel-inn.de/dateien/vba_beispiele/tabellenanzeige_in_html_addin.zip" onclick="window.open(this.href);return false">Tabellendarstellung in Foren Version 5.48</a><br/><br/>

<a href="http://Hajo-Excel.de/index.htm" target="_blank" title="Hajo's Excelseiten">Gruß Hajo</a>

Kahiiooss
06.04.2012, 10:02
Danke Hajo,

ich konnte es leider nicht erklären. Daher musste ich jetzt manuell alles bearbeiten.. Vielen Dank..