Lookup & Import Earliest/Latest Date for Activity?

[ekeithjohnson]

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

[Pecoflyer]

Hi please post a sample sheet ( no pics please) Thx