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