Hi Folks
Not the greatest expert on VBA/macro's so all assistance greatly welcomed.



I have a list consisting of events, the columns are:
Date, time, location, name.

This list can be dated anywhere between a couple of days and several weeks long.
Each user may appear several times on each date.

What i need to do is condense the list down is to show each user only once for each date. Additionally this is to be restricted to between certain hours. eg. 18:30 to 07:00.

Any suggestions and advice would be much appreciated.
Sample file attached.

Attached Files

door sample.xlsx (354.5 KB, 19 views)