XLS 2007: formula to profile users based on daily access

[eltractor67]

Hi,
I have been struggling to find a suitable formula that will help me to segment/profile users based on the number of days in which they access a service in a given month.
I am simplifying my master table greatly but these, below, are the key fields. One clarification, the file contains data for all months. Currently I am manually profiling them, but as the db grows I am in need of a faster solution.
In column 'Duration' I am trying to segment users based on three profiles:
- 'Light' for accessing service (regardless of how many times during said day) during 1 day only;
- 'Medium' for accessing service during 2 days;
- 'Multiple' for accessing service during 3+ days.

Year Month USER ID Day Time of day DURATION
2011 March User #001 3/18/2011 105403 Light
2011 March User #001 3/18/2011 105612 Light
2011 March User #001 3/18/2011 105738 Light
2011 March User #002 3/19/2011 072000 Multiple
2011 March User #002 3/19/2011 131353 Multiple
2011 March User #002 3/20/2011 052114 Multiple
2011 March User #002 3/20/2011 091542 Multiple
2011 March User #002 3/21/2011 141126 Multiple
2011 March User #002 3/21/2011 141714 Multiple
2011 March User #002 3/22/2011 001253 Multiple
2011 March User #002 3/22/2011 002700 Multiple
2011 March User #002 3/23/2011 083758 Multiple
2011 March User #002 3/28/2011 075619 Multiple
2011 March User #002 3/28/2011 075917 Multiple
2011 March User #003 3/1/2011 201717 Medium
2011 March User #003 3/1/2011 230940 Medium
2011 March User #003 3/2/2011 122201 Medium

Users can fall into one profile in April, and in another profile in May depending on the number of days. I think I need a COUNTIFS formula but given that there are multiple conditions, I cant exactly find a solution.
Thanks for any insight, Hope I have included all information.
Cheers again
C.

[Vinodsralian]

Hi, You can add pivot with duration in filter!!

Vinod

[eltractor67]

Hey Vinod,
Thank you for your note. Although I would still prefer to code it in the master file using formulae, I have to admit I have not thought about a pivot with duration. Can you guide me through how to do that?
Thanks so much
Claudio