Anzahl mit bedingung Formel / VBA
01.12.2007 21:07:00
Karel
in erste spalte datumswerte als Text
in vierte spalte belegnr daten
brauch Anzahl Belegnr nach einzel nummer und nach datum sehe beispiel
| A | B | C | D | E | |
| 1 | Datum | BelegNr | anzahl | ||
| 2 | 20071001 | 1 | |||
| 3 | 20071001 | 1 | 2 | ||
| 4 | 20071001 | 8 | |||
| 5 | 20071001 | 8 | |||
| 6 | 20071001 | 8 | 3 | ||
| 7 | 20071001 | 9 | 1 | ||
| 8 | 20071001 | 10 | |||
| 9 | 20071001 | 10 | |||
| 10 | 20071001 | 10 | |||
| 11 | 20071001 | 10 | 4 | ||
| 12 | 20071001 | 11 | |||
| 13 | 20071001 | 11 | |||
| 14 | 20071001 | 11 | 3 | ||
| 15 | 20071001 | 13 | |||
| 16 | 20071001 | 13 | |||
| 17 | 20071001 | 13 | |||
| 18 | 20071001 | 13 | |||
| 19 | 20071001 | 13 | 5 | ||
| 20 | 20071001 | 15 | 1 | ||
| 21 | 20071005 | 1 | |||
| 22 | 20071005 | 1 | 2 | ||
| 23 | 20071005 | 7 | |||
| 24 | 20071005 | 7 | |||
| 25 | 20071005 | 7 | 3 | ||
| 26 | 20071005 | 8 | |||
| 27 | 20071005 | 8 | 2 | ||
| 28 | 20071005 | 9 | |||
| 29 | 20071005 | 9 | 2 | ||
| 30 | 20071005 | 10 | |||
| 31 | 20071005 | 10 | 2 | ||
| 32 | 20071005 | 11 | |||
| 33 | 20071005 | 11 | 2 | ||
| 34 | 20071005 | 12 | 1 | ||
| 35 | 20071005 | 13 | |||
| 36 | 20071005 | 13 | |||
| 37 | 20071005 | 13 | 3 |
Excel Tabellen im Web darstellen >> Excel Jeanie HTML 4
Grusse
Karel
Anzeige