I have a workbook that I want to use to track mail delivery of items.

Each item has a unique tracking number.



I have access to processing data which contains multiple activities (usually about 3 to 5) that has their own date and time stamp, location, etc.

I want to identify & import the earliest date & time in one column (also the last in another column to calculate elapsed system processing time).

What kind of function/formula accomplishes what I desire? Is this possible? It's essentially a lookup but with the added function of identifying the earliest or latest date & time.

Any assistance welcomed. Thanks, Keith