Thread: Lookup?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Drydock Drydock is offline
external usenet poster
 
Posts: 1
Default Lookup?

I have 5 columns of data and I want to write a function to (find) display the
earliest (Min) and Latest (Max) dates for each set of Item #'s.
If I sort by Item #'s how can I display the Max and Min dates for each of
the items

My data consist of about 150 separate items with an average of 50 entry's
per item.

Item Description Name Hours Date
13 Job1 C. Smith 5.00 10/01/07
13 Job1 D.Jones 8.00 10/02/07
13 Job2 F. Bing 6.00 10/01/07
14 Job1 C. Smith 8.00 9/29/07
14 Job1 D. Jones 7.00 9/28/07
15 Job2 F. Bing 6.00 8/31/07
15 Job2 C. Smith 4.00 8/30/01