Is it possible to find the minimum value (earliest time) using an
array?

Column A contains the date field column B is the operation start time
and column C contains the surgeon.

Obviously there will be many operations per day per surgeon - I need to
find the earliest start time for each surgeon on each day.

I can get the start time using an arrray with one criteria but not two,
what is the easiest way of doing this?


--
ultra vires
------------------------------------------------------------------------
ultra vires's Profile: http://www.excelforum.com/member.php...fo&userid=4855
View this thread: http://www.excelforum.com/showthread...hreadid=518224