Unique instances within a certain timeframe, each day, excluding certain criteria

[davidheyburn]

Hi All, I manage an office building where we are attempting to identify the utilization rate of our offices by downloading the door access code data for each office, then identify the unique instances of a door code being used each day, excluding certain users.


based on the image of my data set below, for example, I'm trying to identify unique instances of a specific "Event" on a Specific "Device" within a certain time frame (4am to 7pm) each day, excluding certain users (such as cleaners, or certain staff members - users who would not be unique to the office user).

My Data set is over a 7-day time frame, and Ideally, I would be able to count the number of days within that 7 day window that each office was utilized by the occupant, based on their door code being utilized on that day.

Can anyone help me determine what formula I would need to run?

Thank you!
David

 

[alansidman]

David,
We cannot manipulate data in a picture. Please upload using XL2BB. Also, please identify those users which should be excluded from the analysis.