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

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

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post