D
Drydock
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
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