View Single Post
 
Old 08-24-2014, 10:26 PM
ekeithjohnson ekeithjohnson is offline Windows 7 32bit Office 2013
Novice
 
Join Date: Aug 2014
Posts: 12
ekeithjohnson is on a distinguished road
Question Lookup & Import Earliest/Latest Date for Activity?

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
Reply With Quote