hi everyone,

i have a database as following:

Date Type
1 a
1 d
1 a
2 a
2 b
3 c
3 a
3 d
..
31

Result Here
Date Count
1 ? (result is 3)
2 ? (Result is 1)
..
31

I wanna count, how many a and d are there in Date 1 ??

--
vumia
-----------------------------------------------------------------------
vumian's Profile: http://www.excelforum.com/member.php...fo&userid=3649
View this thread: http://www.excelforum.com/showthread.php?threadid=56834