Formel zu Gross

30.04.2008 12:07:07

Martin

Hallo Zusammen Habe da eine Formel welche mich an die Grenzen der Formelgrösse bringt. Folgendes sollte mit der Formel erledigt werden: In der Zeile A5 bis BA5 stehen Kalenderwochen (KW) In der Zeile A13 bis AN13 stehen die Urlaubsblöcke (UB) immer zwei Zellen bilden einen Block z. _ B. von A13 bis B13 ist der erste UB und davon gibt es 20. In der Zeile A9 bis BA9 wird nun mit einer Formel festgestellt, ob es in jedem der 20 UB eine Ü _ bereinstimmung mit der KW gibt und zwar müssen alle KW die zwischen der Start-KW und der Ende-KW pro Block mitgerechnet werden. Die Formel funktioniert so wie im Beispiel enthalten, jedoch wenn ich dies auf 20 Urlaubsblöcke _ ausdehnen will, gibt es einen Fehler da die Formel zu lang ist. Gibt es da eine andere Formel welche diese Anforderung erfüllen könnte? Danke für Eure Hilfe. Gruss Martin CH PS die Datei ist hier als Download möglich: https://www.herber.de/bbs/user/51977.xls

Tabelle1

	A	B	C	D	E	F	G	H	I	J
3
4	Wochen
5	1	2	3	4	5	6	7	8	9	10
6
7
8	Treffer
9	1	1	0	0	0	1	0	1	1	1
10
11
12	Terminblöcke
13	6	6	8	10	1	2	14	15
14	1		2		3		4		5
15

Formeln der Tabelle

Zelle	Formel
A9	=WENN(ODER(UND(A$5>=$A$13;A$5; UND(A$5>=$C$13;A$5; UND(A$5>=$E$13;A$5); 1;0)
B9	=WENN(ODER(UND(B$5>=$A$13;B$5; UND(B$5>=$C$13;B$5; UND(B$5>=$E$13;B$5); 1;0)
C9	=WENN(ODER(UND(C$5>=$A$13;C$5; UND(C$5>=$C$13;C$5; UND(C$5>=$E$13;C$5); 1;0)
D9	=WENN(ODER(UND(D$5>=$A$13;D$5; UND(D$5>=$C$13;D$5; UND(D$5>=$E$13;D$5); 1;0)
E9	=WENN(ODER(UND(E$5>=$A$13;E$5; UND(E$5>=$C$13;E$5; UND(E$5>=$E$13;E$5); 1;0)
F9	=WENN(ODER(UND(F$5>=$A$13;F$5; UND(F$5>=$C$13;F$5; UND(F$5>=$E$13;F$5); 1;0)
G9	=WENN(ODER(UND(G$5>=$A$13;G$5; UND(G$5>=$C$13;G$5; UND(G$5>=$E$13;G$5); 1;0)
H9	=WENN(ODER(UND(H$5>=$A$13;H$5; UND(H$5>=$C$13;H$5; UND(H$5>=$E$13;H$5); 1;0)
I9	=WENN(ODER(UND(I$5>=$A$13;I$5; UND(I$5>=$C$13;I$5; UND(I$5>=$E$13;I$5); 1;0)
J9	=WENN(ODER(UND(J$5>=$A$13;J$5; UND(J$5>=$C$13;J$5; UND(J$5>=$E$13;J$5); 1;0)

Excel Tabellen im Web darstellen >> Excel Jeanie HTML 4

Erweiterung: Formel zu Gross

30.04.2008 12:59:21

Martin

Hallo nochmals
Habe die Formel so gebaut, dass alle 20 Blöcke berücksichtigt werden, es ist jedoch so, dass diese Prüfung mit einer anderen Tabelle vreknüpft werden sollte und dabei wird die Formel zu lang..

Tabelle1

	A	B	C	D	E	F	G	H
3
4	Wochen
5	1	2	3	4	5	6	7	8
6
7
8	Treffer
9	1	1	0	0	1	1	0	1
10
11
12	Terminblöcke
13	6	6	8	10	1	2	14	15
14	1		2		3		4
15

Formeln der Tabelle

Zelle	Formel
A9	=WENN(ODER(UND(A$5>=$A$13;A$5<=$B$13); UND(A$5>=$C$13;A$5<=$D$13); UND(A$5>=$E$13;A$5<=$F$13); UND(A$5>=$G$13;A$5<=$H$13); UND(A$5>=$I$13;A$5<=$J$13); UND(A$5>=$K$13;A$5<=$L$13); UND(A$5>=$M$13;A$5<=$N$13); UND(A$5>=$O$13;A$5<=$P$13); UND(A$5>=$Q$13;A$5<=$R$13); UND(A$5>=$S$13;A$5<=$T$13); UND(A$5>=$U$13;A$5<=$V$13); UND(A$5>=$W$13;A$5<=$X$13); UND(A$5>=$Y$13;A$5<=$Z$13); UND(A$5>=$AA$13;A$5<=$AB$13); UND(A$5>=$AC$13;A$5<=$AD$13); UND(A$5>=$AE$13;A$5<=$AF$13); UND(A$5>=$AG$13;A$5<=$AH$13); UND(A$5>=$AI$13;A$5<=$AJ$13); UND(A$5>=$AK$13;A$5<=$AL$13); UND(A$5>=$AM$13;A$5<=$AN$13)); 1;0)
B9	=WENN(ODER(UND(B$5>=$A$13;B$5<=$B$13); UND(B$5>=$C$13;B$5<=$D$13); UND(B$5>=$E$13;B$5<=$F$13); UND(B$5>=$G$13;B$5<=$H$13); UND(B$5>=$I$13;B$5<=$J$13); UND(B$5>=$K$13;B$5<=$L$13); UND(B$5>=$M$13;B$5<=$N$13); UND(B$5>=$O$13;B$5<=$P$13); UND(B$5>=$Q$13;B$5<=$R$13); UND(B$5>=$S$13;B$5<=$T$13); UND(B$5>=$U$13;B$5<=$V$13); UND(B$5>=$W$13;B$5<=$X$13); UND(B$5>=$Y$13;B$5<=$Z$13); UND(B$5>=$AA$13;B$5<=$AB$13); UND(B$5>=$AC$13;B$5<=$AD$13); UND(B$5>=$AE$13;B$5<=$AF$13); UND(B$5>=$AG$13;B$5<=$AH$13); UND(B$5>=$AI$13;B$5<=$AJ$13); UND(B$5>=$AK$13;B$5<=$AL$13); UND(B$5>=$AM$13;B$5<=$AN$13)); 1;0)
C9	=WENN(ODER(UND(C$5>=$A$13;C$5<=$B$13); UND(C$5>=$C$13;C$5<=$D$13); UND(C$5>=$E$13;C$5<=$F$13); UND(C$5>=$G$13;C$5<=$H$13); UND(C$5>=$I$13;C$5<=$J$13); UND(C$5>=$K$13;C$5<=$L$13); UND(C$5>=$M$13;C$5<=$N$13); UND(C$5>=$O$13;C$5<=$P$13); UND(C$5>=$Q$13;C$5<=$R$13); UND(C$5>=$S$13;C$5<=$T$13); UND(C$5>=$U$13;C$5<=$V$13); UND(C$5>=$W$13;C$5<=$X$13); UND(C$5>=$Y$13;C$5<=$Z$13); UND(C$5>=$AA$13;C$5<=$AB$13); UND(C$5>=$AC$13;C$5<=$AD$13); UND(C$5>=$AE$13;C$5<=$AF$13); UND(C$5>=$AG$13;C$5<=$AH$13); UND(C$5>=$AI$13;C$5<=$AJ$13); UND(C$5>=$AK$13;C$5<=$AL$13); UND(C$5>=$AM$13;C$5<=$AN$13)); 1;0)
D9	=WENN(ODER(UND(D$5>=$A$13;D$5<=$B$13); UND(D$5>=$C$13;D$5<=$D$13); UND(D$5>=$E$13;D$5<=$F$13); UND(D$5>=$G$13;D$5<=$H$13); UND(D$5>=$I$13;D$5<=$J$13); UND(D$5>=$K$13;D$5<=$L$13); UND(D$5>=$M$13;D$5<=$N$13); UND(D$5>=$O$13;D$5<=$P$13); UND(D$5>=$Q$13;D$5<=$R$13); UND(D$5>=$S$13;D$5<=$T$13); UND(D$5>=$U$13;D$5<=$V$13); UND(D$5>=$W$13;D$5<=$X$13); UND(D$5>=$Y$13;D$5<=$Z$13); UND(D$5>=$AA$13;D$5<=$AB$13); UND(D$5>=$AC$13;D$5<=$AD$13); UND(D$5>=$AE$13;D$5<=$AF$13); UND(D$5>=$AG$13;D$5<=$AH$13); UND(D$5>=$AI$13;D$5<=$AJ$13); UND(D$5>=$AK$13;D$5<=$AL$13); UND(D$5>=$AM$13;D$5<=$AN$13)); 1;0)
E9	=WENN(ODER(UND(E$5>=$A$13;E$5<=$B$13); UND(E$5>=$C$13;E$5<=$D$13); UND(E$5>=$E$13;E$5<=$F$13); UND(E$5>=$G$13;E$5<=$H$13); UND(E$5>=$I$13;E$5<=$J$13); UND(E$5>=$K$13;E$5<=$L$13); UND(E$5>=$M$13;E$5<=$N$13); UND(E$5>=$O$13;E$5<=$P$13); UND(E$5>=$Q$13;E$5<=$R$13); UND(E$5>=$S$13;E$5<=$T$13); UND(E$5>=$U$13;E$5<=$V$13); UND(E$5>=$W$13;E$5<=$X$13); UND(E$5>=$Y$13;E$5<=$Z$13); UND(E$5>=$AA$13;E$5<=$AB$13); UND(E$5>=$AC$13;E$5<=$AD$13); UND(E$5>=$AE$13;E$5<=$AF$13); UND(E$5>=$AG$13;E$5<=$AH$13); UND(E$5>=$AI$13;E$5<=$AJ$13); UND(E$5>=$AK$13;E$5<=$AL$13); UND(E$5>=$AM$13;E$5<=$AN$13)); 1;0)
F9	=WENN(ODER(UND(F$5>=$A$13;F$5<=$B$13); UND(F$5>=$C$13;F$5<=$D$13); UND(F$5>=$E$13;F$5<=$F$13); UND(F$5>=$G$13;F$5<=$H$13); UND(F$5>=$I$13;F$5<=$J$13); UND(F$5>=$K$13;F$5<=$L$13); UND(F$5>=$M$13;F$5<=$N$13); UND(F$5>=$O$13;F$5<=$P$13); UND(F$5>=$Q$13;F$5<=$R$13); UND(F$5>=$S$13;F$5<=$T$13); UND(F$5>=$U$13;F$5<=$V$13); UND(F$5>=$W$13;F$5<=$X$13); UND(F$5>=$Y$13;F$5<=$Z$13); UND(F$5>=$AA$13;F$5<=$AB$13); UND(F$5>=$AC$13;F$5<=$AD$13); UND(F$5>=$AE$13;F$5<=$AF$13); UND(F$5>=$AG$13;F$5<=$AH$13); UND(F$5>=$AI$13;F$5<=$AJ$13); UND(F$5>=$AK$13;F$5<=$AL$13); UND(F$5>=$AM$13;F$5<=$AN$13)); 1;0)
G9	=WENN(ODER(UND(G$5>=$A$13;G$5<=$B$13); UND(G$5>=$C$13;G$5<=$D$13); UND(G$5>=$E$13;G$5<=$F$13); UND(G$5>=$G$13;G$5<=$H$13); UND(G$5>=$I$13;G$5<=$J$13); UND(G$5>=$K$13;G$5<=$L$13); UND(G$5>=$M$13;G$5<=$N$13); UND(G$5>=$O$13;G$5<=$P$13); UND(G$5>=$Q$13;G$5<=$R$13); UND(G$5>=$S$13;G$5<=$T$13); UND(G$5>=$U$13;G$5<=$V$13); UND(G$5>=$W$13;G$5<=$X$13); UND(G$5>=$Y$13;G$5<=$Z$13); UND(G$5>=$AA$13;G$5<=$AB$13); UND(G$5>=$AC$13;G$5<=$AD$13); UND(G$5>=$AE$13;G$5<=$AF$13); UND(G$5>=$AG$13;G$5<=$AH$13); UND(G$5>=$AI$13;G$5<=$AJ$13); UND(G$5>=$AK$13;G$5<=$AL$13); UND(G$5>=$AM$13;G$5<=$AN$13)); 1;0)
H9	=WENN(ODER(UND(H$5>=$A$13;H$5<=$B$13); UND(H$5>=$C$13;H$5<=$D$13); UND(H$5>=$E$13;H$5<=$F$13); UND(H$5>=$G$13;H$5<=$H$13); UND(H$5>=$I$13;H$5<=$J$13); UND(H$5>=$K$13;H$5<=$L$13); UND(H$5>=$M$13;H$5<=$N$13); UND(H$5>=$O$13;H$5<=$P$13); UND(H$5>=$Q$13;H$5<=$R$13); UND(H$5>=$S$13;H$5<=$T$13); UND(H$5>=$U$13;H$5<=$V$13); UND(H$5>=$W$13;H$5<=$X$13); UND(H$5>=$Y$13;H$5<=$Z$13); UND(H$5>=$AA$13;H$5<=$AB$13); UND(H$5>=$AC$13;H$5<=$AD$13); UND(H$5>=$AE$13;H$5<=$AF$13); UND(H$5>=$AG$13;H$5<=$AH$13); UND(H$5>=$AI$13;H$5<=$AJ$13); UND(H$5>=$AK$13;H$5<=$AL$13); UND(H$5>=$AM$13;H$5<=$AN$13)); 1;0)

Excel Tabellen im Web darstellen >> Excel Jeanie HTML 4

AW: Erweiterung: Formel zu Gross

30.04.2008 13:29:00

Gert

Hallo Martin,
die Datei "51977.xls" wird von "firefox" nicht gefunden.
Für Dein Anliegen sollte die Formel "SVERWEIS" oder "WVERWEIS" zuständig sein.
Weitere Hilfe zu den Funktionen findest Du in der "xls_Hilfe" oder hier :
http://www.excelfunktionen.de/base/index.htm
unter "Dr. SVERWEIS"
mfg
Gert

Link inkorrekt

30.04.2008 13:38:00

mumpel

Hallo!
Das liegt daran, dass der TO den Link nicht richtig umgesetzt hat (HTML-Code fehlerhaft).
Hier der korrekte Link: https://www.herber.de/bbs/user/51977.xls

jeweils 2 Nachbarzellen abfragen - Array

30.04.2008 13:58:13

WF

Hi Martin,
das erledigt folgende Arrayformel:
{=(MAX((A5>=(WENN(REST(SPALTE(A13:AN13);2)=1;A13:AN13)))+(A5 Abschluß der Formel mit gleichzeitig Strg / Shift / Enter; - das erzeugt sie.
trapp, trapp, trapp, trapp, trapp, brrrrr
WF
http://www.excelformeln.de/
die ultimative Formelseite

AW: jeweils 2 Nachbarzellen abfragen - Array

30.04.2008 15:17:00

Martin

Hallo WF
Merci
Das hilft mit Weiter... ;o)
Jetzt kanns losgehen.
Gruss
Martin

Erweiterung: Formel zu Gross

30.04.2008 15:14:00

Martin

Hallo nochmals
Habe die Formel so gebaut, dass alle 20 Blöcke berücksichtigt werden, es ist jedoch so, dass diese Prüfung mit einer anderen Tabelle vreknüpft werden sollte und dabei wird die Formel zu lang..

Tabelle1

	A	B	C	D	E	F	G	H
3
4	Wochen
5	1	2	3	4	5	6	7	8
6
7
8	Treffer
9	1	1	0	0	1	1	0	1
10
11
12	Terminblöcke
13	6	6	8	10	1	2	14	15
14	1		2		3		4
15

Formeln der Tabelle

Zelle	Formel
A9	=WENN(ODER(UND(A$5>=$A$13;A$5<=$B$13); UND(A$5>=$C$13;A$5<=$D$13); UND(A$5>=$E$13;A$5<=$F$13); UND(A$5>=$G$13;A$5<=$H$13); UND(A$5>=$I$13;A$5<=$J$13); UND(A$5>=$K$13;A$5<=$L$13); UND(A$5>=$M$13;A$5<=$N$13); UND(A$5>=$O$13;A$5<=$P$13); UND(A$5>=$Q$13;A$5<=$R$13); UND(A$5>=$S$13;A$5<=$T$13); UND(A$5>=$U$13;A$5<=$V$13); UND(A$5>=$W$13;A$5<=$X$13); UND(A$5>=$Y$13;A$5<=$Z$13); UND(A$5>=$AA$13;A$5<=$AB$13); UND(A$5>=$AC$13;A$5<=$AD$13); UND(A$5>=$AE$13;A$5<=$AF$13); UND(A$5>=$AG$13;A$5<=$AH$13); UND(A$5>=$AI$13;A$5<=$AJ$13); UND(A$5>=$AK$13;A$5<=$AL$13); UND(A$5>=$AM$13;A$5<=$AN$13)); 1;0)
B9	=WENN(ODER(UND(B$5>=$A$13;B$5<=$B$13); UND(B$5>=$C$13;B$5<=$D$13); UND(B$5>=$E$13;B$5<=$F$13); UND(B$5>=$G$13;B$5<=$H$13); UND(B$5>=$I$13;B$5<=$J$13); UND(B$5>=$K$13;B$5<=$L$13); UND(B$5>=$M$13;B$5<=$N$13); UND(B$5>=$O$13;B$5<=$P$13); UND(B$5>=$Q$13;B$5<=$R$13); UND(B$5>=$S$13;B$5<=$T$13); UND(B$5>=$U$13;B$5<=$V$13); UND(B$5>=$W$13;B$5<=$X$13); UND(B$5>=$Y$13;B$5<=$Z$13); UND(B$5>=$AA$13;B$5<=$AB$13); UND(B$5>=$AC$13;B$5<=$AD$13); UND(B$5>=$AE$13;B$5<=$AF$13); UND(B$5>=$AG$13;B$5<=$AH$13); UND(B$5>=$AI$13;B$5<=$AJ$13); UND(B$5>=$AK$13;B$5<=$AL$13); UND(B$5>=$AM$13;B$5<=$AN$13)); 1;0)
C9	=WENN(ODER(UND(C$5>=$A$13;C$5<=$B$13); UND(C$5>=$C$13;C$5<=$D$13); UND(C$5>=$E$13;C$5<=$F$13); UND(C$5>=$G$13;C$5<=$H$13); UND(C$5>=$I$13;C$5<=$J$13); UND(C$5>=$K$13;C$5<=$L$13); UND(C$5>=$M$13;C$5<=$N$13); UND(C$5>=$O$13;C$5<=$P$13); UND(C$5>=$Q$13;C$5<=$R$13); UND(C$5>=$S$13;C$5<=$T$13); UND(C$5>=$U$13;C$5<=$V$13); UND(C$5>=$W$13;C$5<=$X$13); UND(C$5>=$Y$13;C$5<=$Z$13); UND(C$5>=$AA$13;C$5<=$AB$13); UND(C$5>=$AC$13;C$5<=$AD$13); UND(C$5>=$AE$13;C$5<=$AF$13); UND(C$5>=$AG$13;C$5<=$AH$13); UND(C$5>=$AI$13;C$5<=$AJ$13); UND(C$5>=$AK$13;C$5<=$AL$13); UND(C$5>=$AM$13;C$5<=$AN$13)); 1;0)
D9	=WENN(ODER(UND(D$5>=$A$13;D$5<=$B$13); UND(D$5>=$C$13;D$5<=$D$13); UND(D$5>=$E$13;D$5<=$F$13); UND(D$5>=$G$13;D$5<=$H$13); UND(D$5>=$I$13;D$5<=$J$13); UND(D$5>=$K$13;D$5<=$L$13); UND(D$5>=$M$13;D$5<=$N$13); UND(D$5>=$O$13;D$5<=$P$13); UND(D$5>=$Q$13;D$5<=$R$13); UND(D$5>=$S$13;D$5<=$T$13); UND(D$5>=$U$13;D$5<=$V$13); UND(D$5>=$W$13;D$5<=$X$13); UND(D$5>=$Y$13;D$5<=$Z$13); UND(D$5>=$AA$13;D$5<=$AB$13); UND(D$5>=$AC$13;D$5<=$AD$13); UND(D$5>=$AE$13;D$5<=$AF$13); UND(D$5>=$AG$13;D$5<=$AH$13); UND(D$5>=$AI$13;D$5<=$AJ$13); UND(D$5>=$AK$13;D$5<=$AL$13); UND(D$5>=$AM$13;D$5<=$AN$13)); 1;0)
E9	=WENN(ODER(UND(E$5>=$A$13;E$5<=$B$13); UND(E$5>=$C$13;E$5<=$D$13); UND(E$5>=$E$13;E$5<=$F$13); UND(E$5>=$G$13;E$5<=$H$13); UND(E$5>=$I$13;E$5<=$J$13); UND(E$5>=$K$13;E$5<=$L$13); UND(E$5>=$M$13;E$5<=$N$13); UND(E$5>=$O$13;E$5<=$P$13); UND(E$5>=$Q$13;E$5<=$R$13); UND(E$5>=$S$13;E$5<=$T$13); UND(E$5>=$U$13;E$5<=$V$13); UND(E$5>=$W$13;E$5<=$X$13); UND(E$5>=$Y$13;E$5<=$Z$13); UND(E$5>=$AA$13;E$5<=$AB$13); UND(E$5>=$AC$13;E$5<=$AD$13); UND(E$5>=$AE$13;E$5<=$AF$13); UND(E$5>=$AG$13;E$5<=$AH$13); UND(E$5>=$AI$13;E$5<=$AJ$13); UND(E$5>=$AK$13;E$5<=$AL$13); UND(E$5>=$AM$13;E$5<=$AN$13)); 1;0)
F9	=WENN(ODER(UND(F$5>=$A$13;F$5<=$B$13); UND(F$5>=$C$13;F$5<=$D$13); UND(F$5>=$E$13;F$5<=$F$13); UND(F$5>=$G$13;F$5<=$H$13); UND(F$5>=$I$13;F$5<=$J$13); UND(F$5>=$K$13;F$5<=$L$13); UND(F$5>=$M$13;F$5<=$N$13); UND(F$5>=$O$13;F$5<=$P$13); UND(F$5>=$Q$13;F$5<=$R$13); UND(F$5>=$S$13;F$5<=$T$13); UND(F$5>=$U$13;F$5<=$V$13); UND(F$5>=$W$13;F$5<=$X$13); UND(F$5>=$Y$13;F$5<=$Z$13); UND(F$5>=$AA$13;F$5<=$AB$13); UND(F$5>=$AC$13;F$5<=$AD$13); UND(F$5>=$AE$13;F$5<=$AF$13); UND(F$5>=$AG$13;F$5<=$AH$13); UND(F$5>=$AI$13;F$5<=$AJ$13); UND(F$5>=$AK$13;F$5<=$AL$13); UND(F$5>=$AM$13;F$5<=$AN$13)); 1;0)
G9	=WENN(ODER(UND(G$5>=$A$13;G$5<=$B$13); UND(G$5>=$C$13;G$5<=$D$13); UND(G$5>=$E$13;G$5<=$F$13); UND(G$5>=$G$13;G$5<=$H$13); UND(G$5>=$I$13;G$5<=$J$13); UND(G$5>=$K$13;G$5<=$L$13); UND(G$5>=$M$13;G$5<=$N$13); UND(G$5>=$O$13;G$5<=$P$13); UND(G$5>=$Q$13;G$5<=$R$13); UND(G$5>=$S$13;G$5<=$T$13); UND(G$5>=$U$13;G$5<=$V$13); UND(G$5>=$W$13;G$5<=$X$13); UND(G$5>=$Y$13;G$5<=$Z$13); UND(G$5>=$AA$13;G$5<=$AB$13); UND(G$5>=$AC$13;G$5<=$AD$13); UND(G$5>=$AE$13;G$5<=$AF$13); UND(G$5>=$AG$13;G$5<=$AH$13); UND(G$5>=$AI$13;G$5<=$AJ$13); UND(G$5>=$AK$13;G$5<=$AL$13); UND(G$5>=$AM$13;G$5<=$AN$13)); 1;0)
H9	=WENN(ODER(UND(H$5>=$A$13;H$5<=$B$13); UND(H$5>=$C$13;H$5<=$D$13); UND(H$5>=$E$13;H$5<=$F$13); UND(H$5>=$G$13;H$5<=$H$13); UND(H$5>=$I$13;H$5<=$J$13); UND(H$5>=$K$13;H$5<=$L$13); UND(H$5>=$M$13;H$5<=$N$13); UND(H$5>=$O$13;H$5<=$P$13); UND(H$5>=$Q$13;H$5<=$R$13); UND(H$5>=$S$13;H$5<=$T$13); UND(H$5>=$U$13;H$5<=$V$13); UND(H$5>=$W$13;H$5<=$X$13); UND(H$5>=$Y$13;H$5<=$Z$13); UND(H$5>=$AA$13;H$5<=$AB$13); UND(H$5>=$AC$13;H$5<=$AD$13); UND(H$5>=$AE$13;H$5<=$AF$13); UND(H$5>=$AG$13;H$5<=$AH$13); UND(H$5>=$AI$13;H$5<=$AJ$13); UND(H$5>=$AK$13;H$5<=$AL$13); UND(H$5>=$AM$13;H$5<=$AN$13)); 1;0)

Excel Tabellen im Web darstellen >> Excel Jeanie HTML 4

Formel zu Gross

Forumthread: Formel zu Gross

6
Beiträge zum Forumthread

Beiträge zu diesem Forumthread

Formel zu Gross

Forumthread: Formel zu Gross

6 Beiträge zum Forumthread Beiträge zu diesem Forumthread

VBA Beispiele zu diesem und ähnlichen Themen

6
Beiträge zum Forumthread

Beiträge zu diesem Forumthread