Hi.
I'm looking for a formula that will return the very first instance of an Event and its subsequent timestamp.
For instance I will have a day of events and each will have a timestamp...but I only want the first unique time each would occur.
e.g.
Event Time
Arrival 11:34
Eat 11:36
Arrival 11:37
Sleep 11:45
Sleep 11:48
Eat 11:52
I only want to return the 11:34 - 11:36 - 11:45 events. I've played with various suppression techniques, but can't quite get it. The times where an event occurs after another that isn't of its same type are the ones that are most troublesome. Help! and Thanks.
Edited by clevername - 27 Nov 2007 at 4:53pm