C
cliff
i have the following data
cdate nos
24/7/2008 12
24/7/2008 16
24/7/2008 23
24/7/2008 35
24/7/2008 42
25/7/2008 16
25/7/2008 25
25/7/2008 32
25/7/2008 43
26/7/2008 04
26/7/2008 13
Now I want to count nos in range 1 to 10,11 to 20, 21 to 30, 31 to 40, 41 to
50
on datewise. Result should be something like this :-
cdate 1-10 11 -20 21-30 31-40 41-50
24/7/2008 0 2 1 1 1
25/7/2008 0 1 1 1 1
26/7/2008 1 1 0 0 0
suppose I want to change range 1 to 5, 6 to 10, 11 to 15,16 to 20, 21 to
25, 26 to 30, 31 to 35,36 to 40 and 41 to 45 etc how to change it?
can u help me out to solve this both problems
thnaks
cliffs
cdate nos
24/7/2008 12
24/7/2008 16
24/7/2008 23
24/7/2008 35
24/7/2008 42
25/7/2008 16
25/7/2008 25
25/7/2008 32
25/7/2008 43
26/7/2008 04
26/7/2008 13
Now I want to count nos in range 1 to 10,11 to 20, 21 to 30, 31 to 40, 41 to
50
on datewise. Result should be something like this :-
cdate 1-10 11 -20 21-30 31-40 41-50
24/7/2008 0 2 1 1 1
25/7/2008 0 1 1 1 1
26/7/2008 1 1 0 0 0
suppose I want to change range 1 to 5, 6 to 10, 11 to 15,16 to 20, 21 to
25, 26 to 30, 31 to 35,36 to 40 and 41 to 45 etc how to change it?
can u help me out to solve this both problems
thnaks
cliffs